SUMXMY2 Function in Excel – Calculate sum of the squares of differences in Excel

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

SUMXMY2 Function in Excel 1

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

SUMXMY2 Function in Excel 2

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:

SUMXMY2 Function in Excel 3

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

previous SUMXMY2 Function in Excel                                                                                                                next SUMXMY2 Function in Excel