Problem - Calculate the Invoice "Total" in cell J15?
Use the SUM function to calculate the worksheet totals in cells I9, I10 and I11?
Use the HLOOKUP function in cell H11 to calculate freight cost based on the shipping class and state to which the shipment is going. Freight Cost can be referenced on the "Freight Cost" lookup table (range E5:N8). Be sure to use appropriate relative and absolute cell references.
Attachment:- Assignment.rar