How to use the SUMX2MY2() function in Excel

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

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.

Background

• The arguments should be numbers or names, arrays, or references containing numbers.
• If an array or reference argument contains text, logical values, or empty cells, those values are ignored. However, cells with the value zero are included.
• If array_x and array_y have a different number of values, the SUMX2MY2() function returns the #N/A error.

The equation for the sum of the difference of squares is:
Σ(x² – y²)

EXAMPLE

The solution for this equation is built for the example (see Figure below) as follows:

1. In two specified ranges:
   • Range A: 4, 5
   • Range B: 2, 3

The square of each value is calculated:

1. • Range A: 16, 25
   • Range B: 4, 9
2. The squared values are summed:
   • Range A: 16 + 25 = 41
   • Range B: 4 + 9 = 13
3. The sums are subtracted (see Figure below):
   41 – 13 = 28