SUMPRODUCT

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

Syntax:

SUMPRODUCT( array_1array_N )

This function returns the sum of the products of all the corresponding values in each of the given array parameters.

Formula:

SUMPRODUCT = i 1m   j 1n   ( k 1N (aij)k )

where:

(aij)k is the value of the k‑th array at index row=i,column=j;
m is the number of rows in each array;
n is the number of columns in each array;
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:B14 with cells C1:C14.

Revisions:

This function was added in Fireworkz 2.00.