Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.
Sample Usage
SUMPRODUCT({1,2,3,4},{5,6,7,8})
SUMPRODUCT(B2:B5,C2:C5)
Syntax
SUMPRODUCT(array1, [array2,..])
- array1 - The first array or range whose entries will be multiplied with corresponding entries in the second such array or range.
- array2, .. - [OPTIONAL] Additional array or range whose entries will be multiplied with corresponding entries in the first such array or range.
Examples
SUMPRODUCT({1,2,3,4},{5,6,7,8}) returns a value of 70.
SUMPRODUCT(B2:B5,C2:C5) returns the sum of the products of corresponding entries in the two arrays..