Excel functions / Math
SUMX2MY2 function
Adds up the differences of the squares of matching values in two ranges.
Syntax
=SUMX2MY2(array_x, array_y)
Arguments
array_x: The first range.array_y: The second range, the same size.
When to use it
SUMX2MY2 gives the sum of x² - y² over pairs of values from two lists.
Examples
Squares of one list less squares of the other
A B C D 1 x y 2 3 1 20 3 4 2 In D2:
=SUMX2MY2(A2:A3, B2:B3)→ 20
Common mistakes
- Not the squared differences. This is x² minus y², not (x - y)². That is SUMXMY2.
SUMX2MY2 in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: SUMX2MY2
- Danish: SUMX2MY2
- Dutch: SOM.X2MINY2
- Finnish: NELIÖSUMMIEN.EROTUS
- French: SOMME.X2MY2
- German: SUMMEX2MY2
- Hungarian: SZUMX2BŐLY2
- Italian: SOMMA.DIFF.Q
- Norwegian: SUMMERX2MY2
- Polish: SUMA.X2.M.Y2
- Portuguese (Brazil): SOMAX2DY2
- Portuguese (Portugal): SOMAX2DY2
- Russian: СУММРАЗНКВ
- Spanish: SUMAX2MENOSY2
- Swedish: SUMMAX2MY2
- Turkish: TOPX2EY2
Try SUMX2MY2 in the playground