How to Use SUMX2MY2 Function

The SUMX2MY2 function returns the sum of the square differences between two arrays.

Formula:

=SUMX2MY2(array_x, array_y)

Explanations:

– Array_x is required, which is the first array.

– Array_y is required, which is the second array.

Cautions:

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

Example: What is the sum of the square differences between Array A and B?

=SUMX2MY2(A2:A11,B2:B11)

The result returns to 280.

Download: SUMX2MY2 Function

Leave a Reply