SUMXMY2

Definition: The SUMXMY2 function in Excel is used to find the sum of the square of the difference between corresponding values in two arrays.

Syntax: ==SUMXMY2(array_x, array_y).

Situation: This formula is appropriate in situations where you need to find the sum of the square of the difference between corresponding values in two arrays.

Example: If you have two arrays A1:A5 and B1:B5 that contain the numbers 1, 2, 3, 4, and 5, you would use the formula =SUMXMY2(A1:A5, B1:B5). This would return a value of 10, which is the sum of the square of the difference between corresponding values in the two arrays.