The SUMTIMES function calculates the sum of the products of corresponding values from two or more arrays.
The array arguments must have the same dimensions or the error message #VALUE will be returned. Non-numeric values will be counted as 0. The array components can be entered as a range.
For example:
SUMTIMES({1,2,3}, {2,3,4}) |
returns 20, that is 1*2 + 2*3 + 3 * 4 |
SUMTIMES({1,2},{3,4}, {5,6}) |
returns 63, that is 1*3*5 + 2*4*6 |
SUMTIMES({2,3; 4,6}, {7,5; 4,9}) |
returns 99, that is 2*7 + 3*5 + 4*4 + 6*9 |
SUMTIMES(A1..B2, D1..E2) |
returns A1*D1 + B1*E1 + A2*D2 + B2*E2 |
See also: