SUMXMY2

SUMXMY2 sum of the squares of differences

Synopsis

SUMXMY2(array0,array1)

Arguments

array0: first cell area

array1: second cell area

Description

SUMXMY2 function returns the sum of the squares of the differences of corresponding values in two arrays. The equation of SUMXMY2 is SUM((x-y)^2).

Note

If array0 and array1 have different number of data points, SUMXMY2 returns #N/A.

Strings and empty cells are simply ignored.

Microsoft Excel Compatibility

This function is Excel compatible.

See also

SUMSQ, SUMX2MY2, SUMX2PY2.