Excel

SUMXMY2 function in Excel

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

=SUMXMY2(array_x, array_y)

SUMXMY2 syntax and parameters

Two arguments, two required.

Formulas you'll actually reuse.

Sum of squared differences — the core of a least-squares fit:
```
=SUMXMY2(B2:B50, C2:C50)
```
Result58240
Root-mean-square error between forecast and actual:
```
=SQRT(SUMXMY2(B2:B50, C2:C50) / ROWS(B2:B50))
```
Result34.5

Same name — your formula ports as-is.

Edit the example — nothing to install.

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

Loading the editor…

What they mean — and the fixes.

More ways Excel gets this done.