SUMPRODUCT
Returns the sum of the products of corresponding ranges or arrays
Syntax
SUMPRODUCT(array1, [array2], [array3], ...)
Parameters
- array1: Required. The first array whose components you want to multiply and then add
- array2: Optional. The second array. All arrays must have the same dimensions
- array3: Optional. Additional arrays, up to 255
Example
=SUMPRODUCT(A1:A5, B1:B5)