Excel SUMX2MY2 Function

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

  1. Click on an empty cell (like F5 )
an 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 SUMX2MY2 function

6. Then select ok

SUMX2MY2 function in excel

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.

How to use SUMX2MY2 function in excel

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:

Examples of SUMX2MY2 function in Excel
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?

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

What is the Return value of SUMX2MY2 function?

It returns a number.

How many arguments does SUMX2MY2 function have?

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?

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

Errors in SUMX2MY2 function

SUMX2MY2 related functions :

Leave a Reply

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