Day 21

Task:

You work in procurement at a manufacturing company, checking a supplier's invoice against the purchase order before it gets approved for payment. The order has four line items, each with its own quantity and unit cost, and nobody wants a helper column of line totals cluttering the sheet just to get one number. Work out the total cost of the order in B6 using a single SUMPRODUCT formula.