How to Use SUMXMY2 Function

The SUMXMY2 function returns the sum of the squares of the differences in two arrays.

Formula:

=SUMXMY2(array_x, array_y)

Explanations:

1. Array_x is required which is the first data array.

2. Array_y is required, which is the second data array.

Cautions:

Array_x and array_y will have the same number of values, otherwise, the function returns the #N/A error.

Example: What is the sum of the squares of differences in Column A and Column B?

=SUMXMY2(A2:A11,B2:B11)

The function is 490.

You can also break down to use the traditional method to check the accuracy. The result is also 490.

Leave a Reply