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

Example

SUMPRODUCT Function
advanced_excel_math_trigonometric_functions.htm
Advertisements