What is SUMX2MY2 Function in Excel?
The SUMX2MY2 function is one of the math functions of Excel.
It Sums the differences between the squares of two corresponding ranges or arrays.
We can find this function in Math & trig category of insert function Tab.
How to use SUMX2MY2 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 SUMX2MY2 function
6. Then select ok
7. In the function arguments Tab you will see SUMX2MY2 function
8. Array _x section is the first range or array of numbers and can be a number or name, array, or reference that contains numbers
9. Array _y section is the second range or array of numbers and can be a number or name, array, or reference that contains numbers
This function will first multiply the first number by two and then minus the second power of the number waiting for the second row, and finally, get the sum of these values.
10. You will see results in the formula result section
Examples of SUMX2MY2 function in Excel
Example 1:
How to use SUMX2MY2 function in excel
You can see examples of SUMX2MY2 function below:
sumx2my2(A2,B2) ----->>>>answer is -3
sumx2my2(A3,B3) ----->>>>answer is -5
sumx2my2(A4,B4) ----->>>>answer is -7
sumx2my2(A5,B5) ----->>>>answer is -9
sumx2my2(A6,B6) ----->>>>answer is -11What is the purpose of SUMX2MY2 function?
It Sums the differences between the squares of two corresponding ranges or arrays.
What is the Return value of SUMX2MY2 function?
It returns a number.
How many arguments does SUMX2MY2 function have?
This function has just 2 Argument.
The argument of SUMX2MY2 function is number.
Array _x section is the first range or array of numbers and can be a number or name, array, or reference that contains numbers.
Array _y section is the second range or array of numbers and can be a number or name, array, or reference that contains numbers.
This function will first multiply the first number by two and then minus the second power of the number waiting for the second row, and finally, get the sum of these values.
The argument of SUMX2MY2 function is required and not optional.
SUMX2MY2(number) = number
Which version of excel supports SUMX2MY2 function?
This function is available for all excel versions (2003-2019)
