# How to use the SUMX2MY2 function

**What is the SUMX2MY2 function?**

The SUMX2MY2 function calculates the sum of the difference of squares of corresponding values in two arrays.

**What is the square?**

In mathematics, the square of a number is the result of multiplying the number by itself. Squaring a number is denoted by x^{2}. For example, 5^{2} means 5 * 5 = 25.

Squaring a number results in a positive result as negative signs are removed in multiplication. (-5)^{2} = 25 Squares grow very rapidly. Already x^{2} reaches large values quickly as x increases, higher powers grow even faster.

The square root is the inverse operation of squaring. âˆš25 = 5, since squaring 5 gives 25. Squaring is used in geometry to calculate area of squares, side length squared = area. Squaring is also used when calculating the area of a circle.

For example,Â A = Ï€ rÂ²

A is the area.

r is the radius.

Ï€ is pi.

The graph of y = x2 is a parabola, symmetric about the origin.

Squares appear frequently in equations in physics, math, statistics, and other fields.

**What is theÂ difference of squares?**

The difference of squares is an algebraic identity that relates the difference between two squared terms to the product of the sum and difference of those terms.

aÂ² - bÂ² = (a + b)(a - b)

Where a and b are numbers.

(a + b)(a - b) equals aÂ² - ab +ba + bÂ² which is aÂ² - bÂ²

For example:

xÂ² - 16 = (x + 4)(x - 4)

The difference of squares formula is useful for factoring expressions and simplifying equations involving squared terms. It reveals the hidden factors in the difference of squares.

**What is the sum of the difference of squares?**

SUMX2MY2 function calculates the sum of xÂ² minus yÂ². The arrays x an y must be equal in size.

SUMX2MY2(array1, array2) = âˆ‘(xÂ² - yÂ²)

### Excel Function Syntax

SUMX2MY2(*array_x*, *array_y*)

### Arguments

array_x |
Required. The first array or range of values. |

array_y |
Required. The second array or range of values. |

### SUMX2MY2 function example

Formula in cell F3:

The first array array_x i 4, 3, and 4, the second array contains 2, 3, and 4.

The sum of the difference of squares

4Â² - 2Â² = 16 - 4 = 12

3Â² - 3Â² = 0

4Â² - 4Â² = 0

The sum is 12 + 0 + 0 equals 12.

### Functions in 'Math and trigonometry' category

The SUMX2MY2 function function is one of 73 functions in the 'Math and trigonometry' category.

## How to comment

How to add a formula to your comment<code>Insert your formula here.</code>

Convert less than and larger than signsUse html character entities instead of less than and larger than signs.

< becomes < and > becomes >

How to add VBA code to your comment[vb 1="vbnet" language=","]

Put your VBA code here.

[/vb]

How to add a picture to your comment:Upload picture to postimage.org or imgur

Paste image link to your comment.

Contact OscarYou can contact me through this contact form