SUMXMY2 function returns the sum of squares of differences of corresponding values in two arrays. @array1 is the first array or range of data points and @array2 is the second array or range of data points. The equation of SUMXMY2 is SUM (x-y)^2.
Strings and empty cells are simply ignored.
If @array1 and @array2 have different number of data points, SUMXMY2 returns #N/A error.
This function is Excel compatible.