SUMPRODUCT(R1, R2)

Description
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.

Parameters
R1
A vector

R2
A vector

Examples
Matrix 1, D4..E5 =
D E
2 3
4 6
Matrix 2, D7..E8 =
D E
-5 0
2 8
SUMPRODUCT(D4..E5, D7..E8) = 46

SUMPRODUCT(D4..D5, D7..E7) = -10

SUMPRODUCT(A1..A2, M1..P4) = Error - incompatible range dimensions