Task 1 of 2
In B8, use one formula to calculate the cost of the whole cart.
Lesson theory
SUMPRODUCT(array1, array2) multiplies the values pair by pair (first with first, second with second, and so on) and adds up the results.
One formula replaces a whole "price x quantity" column plus the total.
=SUMPRODUCT(B2:B6,C2:C6) gives the cost of the whole cart.The classic use is a weighted average: grades weighted by credits:
=SUMPRODUCT(grades,weights)/SUM(weights).
Practice is part of Pro
The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.