What is SUMX2PY2 function in Excel?
The SUMX2PY2 function is one of the math functions of Excel.
It Returns the sum total of the sums of squares of numbers in two corresponding ranges or arrays.
We can find this function in Math & trig category of insert function Tab.
How to use SUMX2PY2 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 SUMX2PY2 function
6. Then select ok
7. In the function arguments Tab you will see SUMX2PY2 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 formula first multiplies the arrays by two and then adds them together
10. You will see results in the formula result section
Examples of SUMX2PY2 function in Excel
Example 1:
How to use SUMX2PY2 function in excel
You can see examples of SUMX2PY2 function below:
sumx2py2(A2,B2) ----->>>>answer is 5
sumx2py2(A3,B3) ----->>>>answer is 13
sumx2py2(A4,B4) ----->>>>answer is 25
sumx2py2(A5,B5) ----->>>>answer is 41
sumx2py2(A6,B6) ----->>>>answer is 61What is the purpose of SUMX2PY2 function?
It Returns the sum total of the sums of squares of numbers in two corresponding ranges or arrays.
What is the Return value of SUMX2PY2 function?
It returns a number.
How many arguments does SUMX2PY2 function have?
This function has just 2 Argument.
The argument of SUMX2PY2 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 formula first multiplies the arrays by two and then adds them together.
The argument of SUMX2PY2 function is required and not optional.
SUMX2PY2(number) = number
Which version of excel supports SUMX2PY2 function?
This function is available for all excel versions (2003-2019)
