What is SUMXMY2 function in Excel?
The SUMXMY2 function is one of the math functions of Excel.
It Sums the squares of the differences in two corresponding ranges or arrays.
We can find this function in Math & trig category of insert function Tab.
How to use SUMXMY2 function in excel
- Click on an empty cell (like F5 )
2. Click on fx icon (or press shift+F3)
3. In the insert function tab you will see all functions
4. Select math and trig category
5. Select SUMXMY2 function
6. Then select ok
7. In the function arguments Tab you will see SUMXMY2 function.
8. Array _x section is the first range or array of values and can be a number or name, array, or reference that contains numbers
9. Array _y section is the second range or array of values and can be a number or name, array, or reference that contains numbers
10. This function returns the sum of squares of the difference between the corresponding values in the two arrays
11. You will see results in the formula result section
Examples of SUMXMY2 function in Excel
Example 1:
How to use SUMXMY2 function in excel
You can see examples of SUMXMY2 function below:
sumxmy2(A2,B2) ----->>>>answer is 4
sumxmy2(A3,B3) ----->>>>answer is 4
sumxmy2(A4,B4) ----->>>>answer is 9
sumxmy2(A5,B5) ----->>>>answer is 9
sumxmy2(A6,B6) ----->>>>answer is 25What is the purpose of SUMXMY2 function?
It Sums the squares of the differences in two corresponding ranges or arrays.
What is the Return value of SUMXMY2 function?
It returns a number.
How many arguments does SUMXMY2 function have?
This function has just 2 Argument.
The argument of SUMXMY2 function is number.
Array _x section is the first range or array of values and can be a number or name, array, or reference that contains numbers.
Array _y section is the second range or array of values and can be a number or name, array, or reference that contains numbers.
This function returns the sum of squares of the difference between the corresponding values in the two arrays.
The argument of SUMXMY2 function is required and not optional.
SUMXMY2(number) = number
Which version of excel supports SUMXMY2 function?
This function is available for all excel versions (2003-2019)
