In This Topic

SUMPRODUCT

In This Topic

This function returns the sum of products of cells. Multiplies corresponding components in the given arrays, and returns the sum of those products.

SUMPRODUCT(*array1*,*array2*,...)

There must be at least two arrays (*array1*, *array2*) and optionally up to 255 arrays (*array3*, ...) as arguments. The arrays must have the same dimension.

Accepts numeric data for all arguments. Returns numeric data.

SUMPRODUCT(A1:A17,B1:B17,C1:C17)

SUMPRODUCT({2,3,5,6,4,7},{5,6,4,4,7,2}) gives the result 114

This function is available in product version 1.0 or later.

PRODUCT | SUM | Math and Trigonometry Functions