SUMPRODUCT(,…)Multiplies corresponding data entries in the given arrays or ranges, and then returns the sum of those products.
If an entry is not numeric, the value zero is used instead. If arrays or range arguments do not have the same dimensions, return #VALUE! error. This function ignores logicals, so using SUMPRODUCT(A1:A5>0) will not work. Instead use SUMPRODUCT(--(A1:A5>0))
This function is Excel compatible.
This function is not OpenFormula compatible. Use ODF.SUMPRODUCT instead.