Documentation/Calc Functions/SUMPRODUCT

Function name:
SUMPRODUCT

Category:
Array

Summary:
Multiplies corresponding elements in the given arrays, and returns the sum of those products.

Syntax:
SUMPRODUCT(Array1; Array2; ...; Array30)

Arguments:
Array1, Array2; ...; Array30 represent arrays whose corresponding elements are to be multiplied.

At least one array must be part of the argument list. If only one array is given, all array elements are summed.

Examples:
=SUMPRODUCT(A1:B3;C1:D3) returns 397.

Calculation: A1*C1 + B1*D1 + A2*C2 + B2*D2 + A3*C3 + B3*D3

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

SUMPRODUCT returns a single number, it is not necessary to enter the function as an array function.

More explanations on top of this page.