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