SUMX2MY2 Function in Excel: Sum of Differences of Squares

SUMX2MY2 Function in Excel: Sum of Differences of Squares 1
⏱ 1 min readUpdated 5 October 2026

Maths & trigLevel: ExpertAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. SUMX2MY2 in practice
  5. Where you will use it
  6. Worked example
  7. Mistakes people make
  8. Related functions

SUMX2MY2 returns Σ(x² – y²) for two matching ranges.

Advertisement

Syntax

=SUMX2MY2(array_x, array_y)
Argument What it means
array_x, array_y Same-size ranges

Examples

Example 1

=SUMX2MY2(CHOOSE(A2,{2,3,9},{1,2,3},{5,5}),CHOOSE(A2,{6,5,11},{1,1,1},{3,4}))

Result: -88. See the worked example table below for more cases.

SUMX2MY2 in practice

Where you will use it

  • Statistics formulas
  • Physics energy differences
  • Coursework

Worked example

CaseFormulaResult
1=SUMX2MY2(CHOOSE(A2,{2,3,9},{1,2,3},{5,5}),CHOOSE(A2,{6,5,11},{1,1,1},{3,4}))-88
2=SUMX2MY2(CHOOSE(A3,{2,3,9},{1,2,3},{5,5}),CHOOSE(A3,{6,5,11},{1,1,1},{3,4}))11
3=SUMX2MY2(CHOOSE(A4,{2,3,9},{1,2,3},{5,5}),CHOOSE(A4,{6,5,11},{1,1,1},{3,4}))25

Results calculated in Excel.

Mistakes people make

MistakeWhat to do instead
Different sizes#N/A
TextIgnored

SUMX2PY2 · SUMXMY2

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZRSQ Function in Excel: How Well a Line FitsExcel Functions A–ZCOVAR Function in Excel: Covariance (Older Name)Excel Functions A–ZHLOOKUP Function in Excel: Look Up Across the Top Row of a Table
Advertisement
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong