SUMX2PY2 Function in Excel – Calculate Sum of the Sum of Squares in Excel

SUMX2PY2 Function in Excel calculates and returns the sum of the sum of squares of numbers that has been passed as input.

SUMX2PY2 Function in Excel 1

The SUMX2PY2 can be decoded as SUM of X2 Plus Y2

Syntax of SUMX2PY2 function in Excel

SUMX2PY2( array_x, array_y )

Argument array are array of numeric values which should be of equal length

 

Example of SUMX2PY2 function in Excel

The spreadsheets below show two examples of the Sum of the sum of squares in Excel.

Formula

SUMX2PY2 Function in Excel 2

The arguments to the SUMX2PY2 function can be given as input directly or as references to cells containing values

So the result will be

Result:

SUMX2PY2 Function in Excel 3

NOTE :  #VALUE! Error occurs if the input arrays have different dimension

previous SUMX2PY2 Function in Excel                                                                                                                next SUMX2PY2 Function in Excel