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
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.
The arguments to the SUMXMY2 function can be given as input directly or as references to cells containing values
So the result will be
NOTE : #VALUE! Error occurs if the input arrays have different dimension