SUMXMY2 : General Usage
1
array_X
array_Y
2
3
4
3
2
5
4
1
6
5
6
7
Result
Formula
Evaluated As
8
35
=SUMXMY2(A2:A4,B2:B4)
=1+9+25
9
9
=SUMXMY2({2;4;7}, {1;6;9})
=1+4+4
10