Excel SUMX2PY2 Function

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

  1. Click on an empty cell (like F5 )
empty cell in excel

2. Click on fx icon (or press shift+F3)

fx icon in excel

3. In the insert function tab you will see all functions

 insert function tab in excel

4. Select math and trig category

5. Select SUMX2PY2 function

6. Then select ok

 excel SUMX2PY2 function

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

How to use SUMX2PY2 function in excel

Examples of SUMX2PY2 function in Excel

Example 1:

How to use SUMX2PY2 function in excel

You can see examples of SUMX2PY2 function below:

Examples of SUMX2PY2 function in Excel
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  61

What 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)

Errors in SUMX2PY2 function

SUMX2PY2 related function

Leave a Reply

Your email address will not be published. Required fields are marked *