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

When to use it

SUMX2PY2 gives the sum of x² + y² over pairs of values from two lists.

Examples

  1. Squares of both lists added

    ABCD
    1xy
    23130
    342

    In D2: =SUMX2PY2(A2:A3, B2:B3) → 30

    Try this example

Common mistakes

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.

Translate a whole formula

Try SUMX2PY2 in the playground

Related functions