Documentation/How Tos/Calc: SUMPRODUCT function
From Apache OpenOffice Wiki
SUMPRODUCT
Returns the sum of the products of corresponding array elements.
Syntax:
SUMPRODUCT(array1; array2; ... array30)
- array1 to array30 are up to 30 arrays or ranges whose corresponding elements are to be multiplied.
- SUMPRODUCT evaluates in array mode, but does not need to be entered as an array formula.
- You can use SUMPRODUCT to calculate the scalar product of two vectors.
- SUMPRODUCT can also be used to sum cells where a specified condition is true - see Conditional Counting and Summation and the example below.
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, SUMIF, SUMSQ, SUMX2MY2, SUMX2PY2, SUMXMY2