Calculates the sum of the squares of differences of values in two arrays.
Sample usage
SUMXMY2({1,2,3},{4,5,6})
SUMXMY2(A2:A9,B2:B9)
Syntax
SUMXMY2(array_x, array_y)
-
array_x– The array or range of values that will be reduced by corresponding entries in array_y, squared and added together. -
array_y– The array or range of values that will be subtracted from corresponding entries in array_x, the result squared and all such results added together.
See also
SUMX2PY2: Calculates the sum of the sums of the squares of values in two arrays.
SUMX2MY2: Calculates the sum of the differences of the squares of values in two arrays.