ExcelHeroThe SUMPRODUCT function
Multiplies ranges row by row and adds the results.
In German Excel: SUMMENPRODUKT
How to write it
=SUMPRODUCT(array1, [array2], …)- array1
- The first range.
- array2
- More ranges of the same size.
💡 Perfect for totals of price × quantity and weighted averages.
Try it
What does the whole order cost?
A
B
C
1
Item
Price
Qty
2
Pen
1.5
10
3
Pad
4
3
4
Ink
12
2
5
Total
Price times quantity, for every row, added up.