SUMPRODUCT
Multiplies matching items in lists, then adds the results.
How it’s written
SUMPRODUCT(list1, list2)Example
| A | B | |
|---|---|---|
| 1 | Qty | Price |
| 2 | 2 | 10 |
| 3 | 3 | 20 |
=SUMPRODUCT(A2:A3,B2:B3)Result: 80
Works out 2×10 plus 3×20.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
It’s the quick way to total quantity times price without a helper column.
Practice it properly
Adding up with SUM gives you real tasks, with your formulas tested on data you haven’t seen.