Calculates the sum of the sums of the squares of values in two arrays.
Sample Usage
SUMX2PY2({1,2,3},{4,5,6})
SUMX2PY2(A2:A9,B2:B9)
Syntax
SUMX2PY2(array_x, array_y)
-
array_x
- The array or range of values whose squares will be added to the squares of corresponding entries inarray_y
and added together. -
array_y
- The array or range of values whose squares will be added to the squares of corresponding entries inarray_x
and added together.
See Also
SUMXMY2
: Calculates the sum of the squares of differences of values in two arrays.
SUMX2MY2
: Calculates the sum of the differences of the squares of values in two arrays.