The SUMXMY2 function calculates the sum of squares of differences of corresponding values in two arrays, according to the formula:
The number of values in both arrays must be the same
For example:
SUMXMY2({4,5,6}, {7,4,3})
returns 19, that is (4 - 7)^2 + (5 - 4)^2 + (6 - 3)^2.
See also: