set-2-values: A collection containing the second set of number values.
Example
Given the following table:
A
B
1
2
7
9
5
3
6
4
11
8
12
=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.