All functions / Math
SUMPRODUCT
Multiplies matching items in arrays, then adds the results.
Syntax
=SUMPRODUCT(array1, [array2], …)
Arguments
array: Ranges or arrays of the same size.
Example
=SUMPRODUCT(B2:B5, C2:C5) → Sum of price × quantity
All functions / Math
Multiplies matching items in arrays, then adds the results.
=SUMPRODUCT(array1, [array2], …)
array: Ranges or arrays of the same size.=SUMPRODUCT(B2:B5, C2:C5) → Sum of price × quantity