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

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

**SUMX2MY2**

It Sums **the differences between the squares** of two corresponding ranges or arrays.

## What is the Return value of **SUMX2MY2** function?

**SUMX2MY2**

It returns a number.

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

**SUMX2MY2**

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?

**SUMX2MY2**

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

## Errors in **SUMX2MY2** function

**SUMX2MY2**