Syntax: SUMPRODUCT(R1, R2)
R1 = a vector
R2 = a vector
SUMPRODUCT returns the sum of products of two vectors. R1 must have the same number of rows and columns as R2, or R1 and R2 can be one-dimensional vectors of the same length.
Examples:
Matrix 1, D4..E5 =
D | E | |
4 | 2 | 3 |
---|---|---|
5 | 4 | 6 |
Matrix 2, D7..E8 =
D | E | |
7 | -5 | 0 |
---|---|---|
8 | 2 | 8 |
SUMPRODUCT(D4..E5, D7..E8) = 46
SUMPRODUCT(D4..D5, D7..E7) = -10
SUMPRODUCT(A1..A2, M1..P4) = Error - incompatible range dimensions
Excel function: SUMPRODUCT