# SUMPRODUCT

Multiplies corresponding components in the given arrays, and returns the sum of those products.

**Syntax**

**SUMPRODUCT**(**array1**,**array2**,array3, ...)

**Array1**, **array2**, array3, ... are 2 to 30 arrays whose components you want to multiply and then add.

- The array arguments must have the same dimensions. If they do not, SUMPRODUCT returns the #VALUE! error value.
- SUMPRODUCT treats array entries that are not numeric as if they were zeros.

**Example**

The following formula multiplies all the components of the two arrays on the preceding worksheet and then adds the products — that is, 3*2 + 4*7 + 8*6 + 6*7 + 1*5 + 9*3.

`SUMPRODUCT({3,4;8,6;1,9}, {2,7;6,7;5,3})`

equals 156

**Remarks**

The preceding example returns the same result as the formula SUM(A1:B3*D1:E3) entered as an array. Using arrays provides a more general solution for doing operations similar to SUMPRODUCT. For example, you can calculate the sum of the squares of the elements in A1:B3 by using the formula SUM(A1:B3^2) entered as an array.