The SUMX2MY2 function returns the sum of the difference of the squares of corresponding values in two collections.
SUMX2MY2(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 |
=SUMX2MY2(A1:A6, B1:B6) returns -158, the sum of the differences of the squares of the values in set-1-values (the collection A1:A6) and the squares of the values in set-2-values (the collection B1:B6). The formula for the first such difference is A12 – B12 or 4 – 49, which is -45. |