Excel like a finance pro.
← The libraryPractice · 2 questions →
Math function
SUMX2MY2
Returns the sum of the difference of squares of corresponding values in two arrays.
Rarely usedDifficulty 1400 · AdvancedUsage rank #359 of 520
When to use it
Sum of (x² - y²) across two arrays. A building block for some regression and physics formulas.
The shape of it
- Syntax
=SUMX2MY2(array_x, array_y)
Worked examples
Two pairs
=SUMX2MY2({2,3},{1,1}) → 11
(4-1) + (9-1).
One pair
=SUMX2MY2({5},{3}) → 16
25 - 9.
Ranges
=SUMX2MY2(A2:A4,B2:B4) → 17
A2:A4 holds 3,4,5 and B2:B4 holds 2,3,4: (9-4)+(16-9)+(25-16).
Worth knowing
- Equals SUMSQ(x) - SUMSQ(y).
- Arrays must be the same size.
- Blanks and text are skipped in pairs.
Where it goes wrong
- #N/A when the arrays have different sizes.
- Text in one array drops the pair from both.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.