SUMPRODUCT Function
Description
The SUMPRODUCT function multiplies corresponding components in the given arrays, and returns the sum of those products.
Syntax
SUMPRODUCT (array1, [array2], [array3] ...)
Arguments
Argument | Description | Required/Optional |
---|---|---|
Array1 | The first array argument whose components you want to multiply and then add. | Required |
Array2, array3... | Array arguments 2 to 255 whose components you want to multiply and then add. | Optional |
Notes
All of the supplied arrays must have the same dimensions.
If just one array is supplied, the function returns the sum of the values in that array.
Non-numeric values in the supplied arrays are treated as the value zero.
Arrays that are supplied directly to the SUMPRODUCT function should be surrounded by curly braces, with values in the same row separated by a comma and each row separated by a semicolon.
If the supplied arrays have different dimensions, SUMPRODUCT returns #VALUE! Error.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016