Excel functions / Math
SUMX2PY2 function
Adds up the sums of the squares of matching values in two ranges.
Syntax
=SUMX2PY2(array_x, array_y)
Arguments
array_x: The first range.array_y: The second range, the same size.
When to use it
SUMX2PY2 gives the sum of x² + y² over pairs of values from two lists.
Examples
Squares of both lists added
A B C D 1 x y 2 3 1 30 3 4 2 In D2:
=SUMX2PY2(A2:A3, B2:B3)→ 30
Common mistakes
- Different sizes. The two lists must be the same size.
SUMX2PY2 in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: SUMX2PY2
- Danish: SUMX2PY2
- Dutch: SOM.X2PLUSY2
- Finnish: NELIÖSUMMIEN.SUMMA
- French: SOMME.X2PY2
- German: SUMMEX2PY2
- Hungarian: SZUMX2MEGY2
- Italian: SOMMA.SOMMA.Q
- Norwegian: SUMMERX2PY2
- Polish: SUMA.X2.P.Y2
- Portuguese (Brazil): SOMAX2SY2
- Portuguese (Portugal): SOMAX2SY2
- Russian: СУММСУММКВ
- Spanish: SUMAX2MASY2
- Swedish: SUMMAX2PY2
- Turkish: TOPX2AY2
Try SUMX2PY2 in the playground