FUNCTION CATALOGUE / MATH & TRIGONOMETRY
SUMPRODUCT Excel function
Multiplies corresponding array values and adds the results.
Correct sentence to use
Multiply corresponding values in [range1] and [range2], then add the products.
Modify this query in PlainFormula →Example formula
=SUMPRODUCT(A2:A10,B2:B10)
Multiplies corresponding array elements and sums the products.
Syntax
SUMPRODUCT(array1, [array2], …)
Argument signature: array1, [array2], …
Compatibility: Commonly available in current Excel; verify platform and locale-specific behaviour.