SUMPRODUCT formula multiplies the corresponding items in the arrays and returns the sum of the results.

Syntax of SUMPRODUCT formula

SUMPRODUCT (array1, [array2, … array_n])

Parameters Details:

array1, array2, … array_n : The ranges of cells or arrays that you wish to multiply. All arrays must have the same number of rows and columns. Minimum two arrays and maximum thirty arrays can be entered.


The SUMPRODUCT function returns a numeric value.
If all arrays provided as parameters do not have the same number of rows and columns, the SUMPRODUCT function will return the #VALUE! error.


  • If there are non-numeric values in the arrays, these values are treated as 0’s by the SUMPRODUCT function.
SUMPRODUCT Formula Example
SUMPRODUCT Formula Example