Documentation/How Tos/Calc: SUMPRODUCT function

SUMPRODUCT

Multiplies corresponding elements in the given ranges, and returns the sum of those products.

Syntax:

SUMPRODUCT(range1; range2; ... range30)

range1 to range30 are up to 30 ranges whose corresponding elements are to be multiplied.

You can use SUMPRODUCT to calculate the scalar product of two vectors.

SUMPRODUCT evaluates in array mode, but does not need to be entered as an array formula.

SUMPRODUCT can also be used to sum cells where a specified condition is true - see Conditional Counting and Summation.

Example:

SUMPRODUCT(A1:B2; C1:D2)

returns A1*C1 + B1*D1 + A2*C2 + B2*D2:

=SUMPRODUCT(A1:A6=”red”; B1:B6=”big”; C1:C6)

returns the sum of cells in C1:C6 whose corresponding entries in the A column are red and in the B column are big.

See also:

SUM function, SUMIF function, SUMSQ function

Conditional Counting and Summation

How To Use Arrays in Calc

Array functions