The SUMX2MY2 function returns the sum of the square differences between two arrays.
– Array_x is required, which is the first array.
– Array_y is required, which is the second array.
– 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?
The result returns to 280.