SUMPRODUCT Function

All versions Math & Trig

The Excel SUMPRODUCT function multiplies corresponding numbers in two or more arrays and adds the products — a powerful one-formula way to do weighted totals and conditional math.

Quick answer:

=SUMPRODUCT({1,2,3},{4,5,6}) = 1*4 + 2*5 + 3*6 = 32

Syntax

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

Argument		Description
`array1`	Required	The first array or range of numbers.
`array2, ...`	Optional	Up to 254 more arrays. All arrays must be the same size; matching elements are multiplied, then summed.

How to use it

With one array, SUMPRODUCT simply adds it. With two or more, it multiplies element-by-element and then totals the results — perfect for “quantity × price” style calculations in a single cell.

=SUMPRODUCT({1,2,3},{4,5,6}) // 4+10+18 = 32

=SUMPRODUCT({10,20,30}) // single array = 60

SUMPRODUCT also handles conditions without array-entry. Multiplying TRUE/FALSE comparisons (which become 1/0) lets it count or sum on multiple criteria — the classic pre-SUMIFS technique.

Booleans to numbers: a comparison like (A1:A9="x") returns TRUE/FALSE. Multiply it (or wrap in --) to coerce to 1/0, then SUMPRODUCT can total the matching rows.

Try it: interactive demo

Live demo

Pick a SUMPRODUCT example to see the formula and its result.

example

Result:

Practice workbook

📊

Download the free SUMPRODUCT practice workbook

Every example on this page, ready to open in Excel — plus practice challenges with answers on a separate tab. No sign-up required.

Frequently asked questions

What does SUMPRODUCT actually do?

It pairs up the arrays you give it, multiplies each set of corresponding values, and adds all the products. SUMPRODUCT({1,2,3},{4,5,6}) = 1×4 + 2×5 + 3×6 = 32.

Do the arrays have to be the same size?

Yes. Every array must have the same number of rows and columns, or SUMPRODUCT returns a #VALUE! error.

Can SUMPRODUCT do conditional sums?

Yes — multiply comparison arrays (which yield TRUE/FALSE = 1/0) by a value array. It was the standard multi-condition technique before SUMIFS existed and still shines for OR logic and array math.

Does SUMPRODUCT need Ctrl+Shift+Enter?

No. SUMPRODUCT handles arrays natively, so a plain Enter is enough even though it works on whole arrays.

Master functions like this in one day

This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related functions: SUM · SUMSQ · SUMIFS · PRODUCT · SUMXMY2