SUMX2MY2

Name

SUMX2MY2 —
SUMX2MY2(array1,array2)

Description

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.

See also

SUMSQ