Excel: SumX2pY2 Function

In Excel, the SumX2pY2 function calculates the sum of the squares of corresponding items in the arrays and returns the sum of the results.

The syntax for the SumX2pY2 function is:

SumX2pY2( array1, array2 )

array1 and array are two ranges or arrays.

Applies To:

For example:

Let's take a look at an example:

=SumX2pY2({1,2;3,4}, {5,6;7,8})

The above example would return 204.

You could also reference ranges in Excel.

Based on the Excel spreadsheet above, you could enter the following formula:

=SumX2pY2(A1:B2, D1:E2)

This would also return the value 204.