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 2 arrays and maximum 30 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