Returns the sum of the products of all the corresponding values in the given arrays.
Syntax:
SUMPRODUCT( array_1 … array_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.