Documentation/Calc Functions/SUMPRODUCT

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


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)

Returns:

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.

Additional details:

Examples:

A B C D
1 2 3 4 5
2 6 7 8 9
3 10 11 12 13

=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.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: