SUMX2MY2 function returns the sum of the difference of squares 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 SUMX2MY2 is SUM (x^2-y^2).
Strings and empty cells are simply ignored.
If @array1 and @array2 have different number of data points, SUMX2MY2 returns #N/A error.
This function is Excel compatible.