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 returns #VALUE!. Make both arrays exactly the same dimensions.
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.