SUMXMY2 (Numbers1, Numbers2) SUMXMY2 (Numbers1; Numbers2)
Numbers1
The first set of values. This array must have the same size as the other array parameter.
Numbers2
The second set of values. This array must have the same size as the other array parameter.
Returns
Number Number
The sum of the squared differences between the corresponding elements of the given two arrays.
Returns the sum of the squared differences between the corresponding elements of the given two arrays.
Examples
SUMXMY2 ({ 1, 2, 3 }, { 4, 5, 6 })
SUMXMY2 ({ 1; 2; 3 }; { 4; 5; 6 })