SUMX2PY2 Function in Excel: Sum of Sums of Squares

SUMX2PY2 Function in Excel: Sum of Sums 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. SUMX2PY2 in practice
  5. Where you will use it
  6. Worked example
  7. Mistakes people make
  8. Related functions

SUMX2PY2 returns Σ(x² + y²).

Advertisement

Syntax

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

Examples

Example 1

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

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

SUMX2PY2 in practice

Where you will use it

  • Vector length calculations
  • Statistics
  • Coursework

Worked example

CaseFormulaResult
1=SUMX2PY2(CHOOSE(A2,{2,3,9},{1,2,3},{5,5}),CHOOSE(A2,{6,5,11},{1,1,1},{3,4}))276
2=SUMX2PY2(CHOOSE(A3,{2,3,9},{1,2,3},{5,5}),CHOOSE(A3,{6,5,11},{1,1,1},{3,4}))17
3=SUMX2PY2(CHOOSE(A4,{2,3,9},{1,2,3},{5,5}),CHOOSE(A4,{6,5,11},{1,1,1},{3,4}))75

Results calculated in Excel.

Mistakes people make

MistakeWhat to do instead
Different sizes#N/A
TextIgnored

SUMX2MY2 · SUMSQ

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

Keep reading

Excel Functions A–ZTIMEVALUE Function in Excel: Text Time to Real TimeExcel Functions A–ZCOTH Function in Excel: Hyperbolic CotangentExcel Functions A–ZBESSELJ Function in Excel: Bessel Function Jn(x)
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