Skip to main content

SUMPRODUCT function

The SUMPRODUCT function is one of the math and trigonometry functions. It is used to multiply the values in the selected ranges of cells or arrays and return the sum of the products.

Syntax​

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

The SUMPRODUCT function has the following arguments:

ArgumentDescription
array1/2/3/nUp to 255 ranges of cells or arrays containing numeric values.

Notes​

If the array1/2/3/n contains non-numeric values, the function will treat them as 0.

How to apply the SUMPRODUCT function.

Examples​

The figure below displays the result returned by the SUMPRODUCT function.

SUMPRODUCT Function