Whole document tree SUMXMY2DescriptionSUMXMY2 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. |