Excel like a finance pro.
← The libraryPractice · 2 questions →
Math function
SUMX2PY2
Returns the sum of the sum of squares of corresponding values in two arrays.
Rarely usedDifficulty 1400 · AdvancedUsage rank #360 of 520
When to use it
Sum of (x² + y²) across two arrays.
The shape of it
- Syntax
=SUMX2PY2(array_x, array_y)
Worked examples
Two pairs
=SUMX2PY2({2,3},{1,1}) → 15
(4+1) + (9+1).
One pair
=SUMX2PY2({3},{4}) → 25
9 + 16.
Ranges
=SUMX2PY2(A2:A4,B2:B4) → 79
A2:A4 holds 3,4,5 and B2:B4 holds 2,3,4.
Worth knowing
- Equals SUMSQ(x) + SUMSQ(y).
- Arrays must be the same size.
- Rarely needed; SUMSQ over both ranges is clearer.
Where it goes wrong
- #N/A when sizes differ.
- Text pairs are skipped.
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.