Skip to content
Google Sheets

SUMXMY2 function in Google Sheets

Calculates the sum of the squares of differences of values in two arrays.

=SUMXMY2(array_x, array_y)

SUMXMY2 syntax and parameters

Two arguments, two required.

  • array_xarrayRequired

    The array or range of values that will be reduced by corresponding entries in array_y, squared, and added together.

  • array_yarrayRequired

    The array or range of values that will be subtracted from corresponding entries in array_x, the result squared, and all such results added together.

SUMXMY2 examples

Formulas you'll actually reuse.

  1. Sum of squared differences — the core of a least-squares fit:

    =SUMXMY2(B2:B50, C2:C50)

    Result58240

  2. Root-mean-square error between forecast and actual:

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

    Result34.5

SUMXMY2 in Excel

Same name — your formula ports as-is.

Try SUMXMY2 in the playground

Edit the example — nothing to install.

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

Loading the editor…

SUMXMY2 errors

What they mean — and the fixes.

  • #N/A

    The two arrays have different numbers of values.

Related functions

More ways Google Sheets gets this done.