SUMX2MY2 Excel Formula

Author Zaheer    Category Formulas     Tags ,

One of the uses of Microsoft Excel is to perform mathematical calculations. It has the ability to perform mathematical calculations from simple to the complex ones. This function of Excel would really benefit the users especially those students in the fields of mathematics, science and engineering. Working with mathematical problems is really hard since you need to memorize lots of mathematical constants, equations and relationships. Also, doing it manually really takes some time because of the long process.

However, because of the powerful functions of Microsoft Excel, difficult tasks are turned to easy ones. The functions can really help the users to perform tasks such as manipulating, organizing and analyzing data automatically and in a very easy way. One of the mathematical functions that Excel can offer is the SUMX2MY2 function. Having knowledge about the basic description of this function is a good start to learn before going into the deeper concepts. This article will provide you an overview of the function including some examples that will enable you to learn its usage.

Overview of the SUMX2MY2 in Microsoft Excel

The SUMX2MY2 function is Microsoft Excel is used to calculate the sum of the differences of squares of two supplied array of data. The function follows this formula in calculating the result:

SUMX2MY2 = ?(x2– y2)

The syntax of the SUMX2MY2 function is:

=SUMX2MY2 ( array_x, array_y)

In this formula, the arguments are two sets of numbers, which may be entered in the formula either as cell references containing the numbers or even the actual numeric values. In supplying the argument, you must remember that the two ranges of values should be of equivalent length.

You have to take note that if you have entered non-numeric values in the formula including cells which contain text representations of the numeric values, these values and the values in the other range which correspond to that are ignored.

Here are some examples for you to learn the usage of the SUMX2MY2 function in Excel:

  • For instance, these values are contained in the following cells, this will be your array_x argument: A1 = 5, A2 = 2 and A3 = 3. Moreover, the following cells contain these values, this will be your array_y argument: B1 = 3, B2 =-1 and B3 = 4.
  • Then type in this formula in any cell where you want to display the result, =SUMX2MY2 (A1:A3, B1:B3). The function will perform the calculation in this manner: (52 – 32) + (22 – (-12)) + (32 – 42), giving the result of 12. Then the function will automatically return the result which is 12.
  • You can also use the formula in this way, =SUMX2MY2 (A1:A3, {2;1;0}). The function will calculate for the answer in this manner: (52 – 22) + (22 – 12) + (32 – 02), giving the result of 33. The function will return the result which is 33.

For you to learn more, you can try these examples in your own Excel spreadsheet so that you could practice using the SUMX2MY2 function since you can gain more knowledge with practical applications.

Post comment