SUMX2PY2

SUMX2PY2 sum of the sum of squares

Synopsis

SUMX2PY2(array0,array1)

Arguments

array0: first cell area

array1: second cell area

Description

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

Note

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

Strings and empty cells are simply ignored.

Microsoft Excel Compatibility

This function is Excel compatible.

See also

SUMSQ, SUMX2MY2.