SUMXMY2 Function in Excel calculates and returns the sum of the squares of differences of numbers that has been passed as input.
The SUMXMY2 can be decoded as SUM of (X Minus Y) 2
Syntax of SUMXMY2 function in Excel
SUMXMY2( array_x, array_y )
Argument array are array of numeric values which should be of equal length
Example of SUMXMY2 function in Excel
The spreadsheets below show two examples of sum of the squares of differences in Excel.
Formula
The arguments to the SUMXMY2 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