## What is SUMXMY2 function in Excel?

The **SUMXMY2 **function is one of the math functions of Excel.

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

We can find this function in **Math & trig** category of insert function Tab.

## How to use SUMXMY2 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 **SUMXMY2 **function

6. Then select **ok**

7. In the function **arguments **Tab you will see ** SUMXMY2 **function.

8. **Array _x ** section is the **first range** or **array of values** and can be a number or name, array, or reference that **contains **numbers

9. **Array _y** section is the **second range** or **array of values **and can be a number or name, array, or reference that **contains **numbers

10. This function returns the **sum of squares** of the difference between the corresponding values in the** two arrays**

11. You will see **results **in the formula result section

## Examples of **SUMXMY2** function in Excel

**Example 1:**

**How to use SUMXMY2 function in excel**

You can see examples of SUMXMY2 function below:

**sumxmy2**(A2,B2) ----->>>>answer is 4
**sumxmy2**(A3,B3) ----->>>>answer is 4
**sumxmy2**(A4,B4) ----->>>>answer is 9
**sumxmy2**(A5,B5) ----->>>>answer is 9
**sumxmy2**(A6,B6) ----->>>>answer is 25

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

**SUMXMY2**

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

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

**SUMXMY2**

It returns a number.

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

**SUMXMY2**

This function has just **2** Argument.

The **argument **of SUMXMY2 function is **number**.

**Array _x ** section is the **first range** or **array of values** and can be a number or name, array, or reference that **contains **numbers.

**Array _y** section is the **second range** or **array of values **and can be a number or name, array, or reference that **contains **numbers.

This function returns the **sum of squares** of the difference between the corresponding values in the** two arrays**.

The argument of SUMXMY2 function is **required **and not optional.

```
SUMXMY2(number) = number
```

## Which version of excel supports **SUMXMY2** function?

**SUMXMY2**

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

## Errors in **SUMXMY2** function

**SUMXMY2**