Skip to content
Excel

SUMPRODUCT function in Excel

Returns the sum of the products of corresponding array components

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

SUMPRODUCT syntax and parameters

Three arguments, one required.

  • array1arrayRequired

    The first array argument whose components you want to multiply and then add.

  • array2arrayOptional
  • array3arrayRepeating

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 Google Sheets

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 Excel gets this done.