|
SUMPRODUCT(R1, R2) |
|
Description
This function 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 two one-dimensional vectors of the same length.
Parameters
R1
A range.
R2
A range.
Examples
Given:
D4:E5 =
|
D |
E |
4 |
2 |
3 |
5 |
4 |
6 |
D7:E9 =
|
D |
E |
7 |
-5 |
0 |
8 |
2 |
8 |
9 |
1 |
4 |
SUMPRODUCT(D4:E5, D7:E8) = 46
SUMPRODUCT(D4:D5, D7:E7) = -10
SUMPRODUCT(D4:D5, D7:D9) = #Error
Incompatible range dimensions.
Sponsored
Try Predictive Systems Lab
Need Help?
Contact support