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:

Argument	Description
array1/2/3/n	Up 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.