## 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 61

## What is the purpose of **SUMX2PY2** function?

**SUMX2PY2**

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?

**SUMX2PY2**

It returns a number.

## How many arguments does **SUMX2PY2** function have?

**SUMX2PY2**

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?

**SUMX2PY2**

This function is available for all excel **versions **(2003-2019)

## Errors in **SUMX2PY2** function

**SUMX2PY2**