SUMX2PY2

Calculates the sum of squared values in the first array plus squared values in the second array, element by element. Arrays must be the same size.

Parameter List

Syntax
SUMX2PY2(array_xarray_y)
array_x

The first array or range of values to square. For example: A1:A3.

array_y

The second array or range of values to square and add. Must be the same size as array_x. For example: B1:B3.

More details

SUMX2PY2 computes the sum of the sums of the squares of values in two arrays: ∑(x² + y²). Each element in array_x is squared and added to the square of the corresponding element in array_y. Both arrays must have the same length; otherwise the function returns an error.

Examples

SUMX2PY2(A1:A2, B1:B2) returns 30