Skip to content
Excel

SUMX2PY2 function in Excel

Returns the sum of the sum of squares of corresponding values in two arrays

=SUMX2PY2(array_x, array_y)

SUMX2PY2 syntax and parameters

Two arguments, two required.

  • array_xarrayRequired

    The first array or range of values.

  • array_yarrayRequired

    The second array or range of values.

SUMX2PY2 examples

Formulas you'll actually reuse.

  1. Σ(x² + y²) — the total squared magnitude of paired coordinates:

    =SUMX2PY2(B2:B50, C2:C50)

    Result96200

  2. The root-mean-square distance from the origin:

    =SQRT(SUMX2PY2(B2:B50, C2:C50) / ROWS(B2:B50))

    Result44.3

SUMX2PY2 in Google Sheets

Same name — your formula ports as-is.

Try SUMX2PY2 in the playground

Edit the example — nothing to install.

Preloaded with the SUMX2PY2 formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.