SUMX2PY2 Function

Returns the sum of the sums of squares of two arrays (Σ x² + y²).

Category

Math & Trig

Available in

All versions, Microsoft 365

Returns

A number

Want to practice SUMX2PY2 in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

SUMX2PY2 squares both values in each pair, adds them, and totals the results.

It's mainly found in statistics and engineering formulas.

Syntax

=SUMX2PY2(array_x, array_y) Explain

Arguments

ArgumentRequired?What it does
array_xYesThe first range.
array_yYesThe second range, same size.

Examples

Example 1 — x² + y² for each pair

(2² + 1²) + (3² + 2²) + (4² + 3²).

C2fx=SUMX2PY2(A2:A4, B2:B4)
ABC
1xyResult
22143
332
443
=SUMX2PY2(A2:A4, B2:B4) Explain

Common mistakes

  • Different sizes. Return #N/A.

Notes

  • Related functions: SUMX2MY2, SUMXMY2, SUMSQ.
Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.