Formulas > =SUMPRODUCT()
How To Use SUMPRODUCT() Function in Google Sheets
Description
How To Actually Use SUMPRODUCT() in Sheets
SUMPRODUCT(array1, [array2, ...])
Try SUMPRODUCT yourself
In cells A1:A5, enter the quantities sold of five products, and in cells B1:B5, enter the prices of those products. Use the SUMPRODUCT formula to calculate the total sales in cell C1.
Hints (2)
-
Remember to multiply corresponding entries in the two ranges.
-
Ensure both ranges have the same number of rows.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the SUMPRODUCT() formula:
Generate a SUMPRODUCT() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses SUMPRODUCT(). 2 free AI generations, no signup. Members get unlimited use.
Generate a SUMPRODUCT() formula