ODF.SUMPRODUCT

ODF.SUMPRODUCT multiplies components and adds the results

Synopsis

ODF.SUMPRODUCT(,…)

Description

Multiplies corresponding data entries in the given arrays or ranges, and then returns the sum of those products.

Note

If an entry is not numeric or logical, the value zero is used instead. If arrays or range arguments do not have the same dimensions, return #VALUE! error. This function differs from SUMPRODUCT by considering booleans.

Microsoft Excel Compatibility

This function is not Excel compatible. Use SUMPRODUCT instead.

OpenDocument Format (ODF) Compatibility

This function is OpenFormula compatible.