The Excel SUMXMY2 Function

Related Functions:

Function Description

The Excel Sumxmy2 function returns the sum of the squares of differences between corresponding values in two supplied arrays. I.e.

Equation for Sum of Squares of Differences

The syntax of the Sumxmy2 function is:

SUMXMY2( array_x, array_y )

where the array arguments are two arrays of numeric values. These two arrays must be of equal length.

Note that, if any of the values supplied to the functions are non-numeric (including text representations of numbers), these values, and the corresponding value in the other array are ignored.

Sumxmy2 Function Examples

  A B C D
1 array_x array_y Sumxmy2  
2 5 3 =SUMXMY2( A2:A4, B2:B4 )
3 2 1 =SUMXMY2( A2:A4, {2;1;0} )
4 3 2    
  A B C D
1 array_x array_y Sumxmy2  
2 5 3 6 = 4 + 1 + 1
3 2 1 19 = 9 + 1 + 9
4 3 2    

The above spreadsheets on the right show two examples of the Sumxmy2 function.

The functions are shown in the top spreadsheet and the resulting values are shown in the spreadsheet below.

Note that the examples spreadsheets show that the array arguments can be supplied either directly to the function or in the form of arrays of cells.

See the Microsoft Office website for further information and examples of the Excel Sumxmy2 function.

Sumxmy2 Function Error

If you get an error from the Excel Sumxmy2 Function, this is likely to be the #N/A error:

Common Error
#N/A - Occurs if the array_x and array_y arguments have different lengths (i.e. contain different numbers of values).