Articles with the tag:
Close
Changelog
Close
Articles with the tag:
Close
Try in the cloud

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.

SUMPRODUCT Function

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action