SUMPRODUCT

Returns the sum of the products of all the corresponding values in the given arrays.

Syntax:

SUMPRODUCT(array_1array_N)

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 2.00.