SUMX2PY2 Function in Excel calculates and returns the sum of the sum of squares of numbers that has been passed as input.
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
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:
NOTE : #VALUE! Error occurs if the input arrays have different dimension