Navigation:  Formula Reference > Spreadsheet Formula Functions >

SUMPRODUCT

Previous pageReturn to chapter overviewNext page

 

This function 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,...)

Arguments

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 Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

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

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

 

See Also

PRODUCT

SUM