SUMPRODUCT
Name
Sum product
Description
Returns the sum of products of cells. Multiplies corresponding components in the given arrays, and returns the sum of those products.
Syntax
SUMPRODUCT(array1, array2, . . . )
Remarks
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.
Data Type
Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
SUMPRODUCT(A1:A17,B1:B17,C1:C17)
SUMPRODUCT({2,3,5,6,4,7},{5,6,4,4,7,2})=114