Skip to content
Google Sheets

SUMPRODUCT function in Google Sheets

Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.

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

SUMPRODUCT syntax and parameters

Two arguments, one required.

  • array1arrayRequired

    The first array or range whose entries will be multiplied with corresponding entries in the second such array or range.

  • array2arrayRepeating

    [ OPTIONAL - {1,1,1,...} with same length as array1 by default ] - The second array or range whose entries will be multiplied with corresponding entries in the first such array or range.

SUMPRODUCT examples

Formulas you'll actually reuse.

  1. Order total from quantity × unit price, no helper column:

    =SUMPRODUCT(B2:B50, C2:C50)

    Result12480.5

  2. A conditional sum with array logic — like SUMIFS, but OR is a + away:

    =SUMPRODUCT((A2:A200 = "West") * (C2:C200 > 1000) * C2:C200)

    Result41200

SUMPRODUCT in Excel

Same name — your formula ports as-is.

Try SUMPRODUCT in the playground

Edit the example — nothing to install.

Preloaded with the SUMPRODUCT formula from Example 1 — change anything and watch it respond.

Loading the editor…

SUMPRODUCT errors

What they mean — and the fixes.

  • #VALUE!

    The arrays have different sizes — every array must have the same number of rows and columns.

Related functions

More ways Google Sheets gets this done.