SUMX2PY2

Excel Functions

Get sum of squares in two arrays

Syntax

EXCEL

=SUMX2PY2(array_x, array_y)

Arguments

Parameter	Description
`array_x`	The first range or array containing numeric values.
`array_y`	The second range or array containing numeric values.

Return Value

Calculated sum of sum of squares

Details

The SUMX2PY2 function returns the sum of the sum of squares of corresponding values in two arrays. The "p" in the function name stands for "plus", as in "sum x2 plus y2". SUMX2PY2 takes two arguments, array_x and array_y. Array_x is the first range or array or range of numbers, and array_y is the second range or array of numbers. Both arguments can be provided as an array constant or as a range. In the example shown above, the formula in E5 is: which returns 600 as a result. The equation used to calculate the sum of the sum of squares is:

Examples

EXCEL

=SUMX2PY2({1,2},{1,2}) // returns 10
=SUMX2PY2({1,2,3},{1,2,3}) // returns 28

Examples

In the example shown above, the formula in E5 is:

EXCEL

=SUMX2PY2(B5:B12,C5:C12)

Equation

This formula can be created manually in Excel with the exponentiation operator (^) like this:

EXCEL

=SUM((range1^2)+(range2^2))

Equation

With the example as shown, the formula below will return the same result as SUMX2PY2:

EXCEL

=SUM((B5:B12^2)+(C5:C12^2)) // returns 600

SUMX2PY2

Syntax

Arguments

Return Value

Details

Examples

See Also