Skip to content
Excel

SUMX2MY2 function in Excel

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

=SUMX2MY2(array_x, array_y)

SUMX2MY2 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.

SUMX2MY2 examples

Formulas you'll actually reuse.

  1. Σ(x² − y²) — how much larger the squares of one series are than the other's:

    =SUMX2MY2(B2:B50, C2:C50)

    Result18400

  2. That difference relative to the second series:

    =SUMX2MY2(B2:B50, C2:C50) / SUMSQ(C2:C50)

    Result0.42

SUMX2MY2 in Google Sheets

Same name — your formula ports as-is.

Try SUMX2MY2 in the playground

Edit the example — nothing to install.

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

Loading the editor…

Related functions

More ways Excel gets this done.