Returns the sum of the products of all the corresponding values in the given arrays.
Syntax:
The SUMPRODUCT
function returns the sum of the products of all the corresponding values
in each of the given array parameters.
The equation used is:
Σi=m Σj=n ( Πk=N (aij)k )
where (aij)k is the value of the
k-th array at index row=i,column=j,
m and n are the numbers of rows and columns respectively in each array and
N is the number of arrays.
Example:
SUMPRODUCT(B1:B14, C1:C14)
returns the sum of the products of the corresponding values of cells B1
to B14
with cells C1
to C14
.
Added in 1.36.