Multiply quantity × price (or any two columns) row by row and total the result.
Copy this formula
=SUMPRODUCT(A2:A100, B2:B100)SUMPRODUCT multiplies the matching cells of each array and adds up all the products in one step — no helper column needed. It's the classic way to total revenue from quantity and price columns.
=SUMPRODUCT(Qty, Price)→12,480Total revenue across all rows.
=SUMPRODUCT({2,3,4}, {10,20,30})→2002×10 + 3×20 + 4×30 = 200.
=SUMPRODUCT((C2:C100="East")*A2:A100*B2:B100)→5,300Multiplies and sums only the rows where column C is East.
SUMPRODUCT returns #VALUE!. Make both arrays exactly the same dimensions.
No. SUMPRODUCT handles arrays natively, so it works with a normal Enter in every Excel version.
SUMPRODUCT treats non-numeric entries as zero, so those rows add nothing to the total.
Yes. Add another range: =SUMPRODUCT(A2:A100, B2:B100, C2:C100). All ranges must be the same size.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.