The SUMXMY2 function returns the sum of the squares of the differences between corresponding values in two collections.
SUMXMY2(set-1-values, set-2-values)
set-1-values: A collection containing the first set of number values.
set-2-values: A collection containing the second set of number values.
Example |
|---|
Given the following table: |
A | B | |
|---|---|---|
1 | 2 | 7 |
2 | 9 | 5 |
3 | 3 | 6 |
4 | 11 | 8 |
5 | 1 | 12 |
6 | 5 | 9 |
=SUMXMY2(A1:A6, B1:B6) returns 196, the sum of the squares of the differences of the values in set-1-values (the collection A1:A6) and the values in set-2-values (the collection B1:B6). The formula for the first such difference is (A1 – B1)2 or (2 – 7)2, which is 25. |