Function reference /Math & aggregation

SUMPRODUCT

Run in a real sheet

Multiplies ranges together row by row, then adds up the results.

SUMPRODUCT(array1, [array2, ...])

SUMPRODUCT is units times price, summed — revenue, weighted scores, hours times rate — in one cell, with no helper column. Put a condition in brackets and it becomes a multi-condition SUMIF too.

Executed 26 Sep 2026 Google Sheets · unedited screenshot
=SUMPRODUCT(B2:B5, C2:C5) running in Google Sheets, returning 7580
The formula sits in the formula bar and its answer sits in the grid, in one frame. 4×1200 + 20×25 + 6×300 + 8×60 — each row's units times its price, added up.

Worked example

ProductUnitsPrice
Laptop41200
Mouse2025
Monitor6300
Keyboard860
 
=SUMPRODUCT(B2:B5, C2:C5)

Returns 7580.

Arguments

ArgumentRequiredWhat it does
array1 Yes The first range of numbers.
array2, ... Optional More ranges the same size. Each row is multiplied across them before the sum.

Gotchas

  • 01Every range must be the same size. A mismatch is an error, not a partial answer.
  • 02A condition in brackets turns into 1 or 0: =SUMPRODUCT((A2:A5="Laptop")*B2:B5*C2:C5) totals only the Laptop rows.
  • 03In a pivot table calculated field, =Units*Price with Summarize by SUM multiplies the group's totals, not its rows — two Laptop rows of 4 and 2 at 1200 come out as 6×2400 = 14400. Set Summarize by to Custom and write =SUMPRODUCT(Units,Price) to get the right 7200.