SUMX2PY2 (sum of x^2 + y^2)

<< Click to Display Table of Contents >>

SUMX2PY2 (sum of x^2 + y^2)

Syntax:

SUMX2PY2(Range1, Range2)

Description:

Returns the sum of the sum of squares of corresponding values in two arrays.

The equation for this function is:

SUMX2PY2 = (x^2 + y^2)

Range1 and Range2 are the arrays containing the values to be evaluated. As a rule, the cell ranges in which the values are contained must be specified here.

Both ranges must have the same dimensions (height and width), otherwise the function returns a #N/A error value.

Pairs of values where at least one value is an empty cell or a non-numerical value (text string or logical value) are ignored.

Example:

Cells A1 to A3 contain the following values: 9, 4, 7

Cells B1 to B3 contain the following values: 1, 0, 5

If you calculate SUMX2PY2(A1:A3, B1:B3) here, this is equivalent to the following calculation

(9^2) + (1^2) + (4^2) + (0^2) + (7^2) + (5^2)

The result is 172.

See also:

SUM, SUMPRODUCT, SUMX2MY2, SUMXMY2, SUMSQ