SUMTIMES(range1, range2, range3…)

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:

Other mathematical functions