81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



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

How To Use in Sheets

SUMX2MY2(array_x, array_y)

External Links

Excel SUMX2MY2 Function - How to use SUMX2MY2 Function

The Microsoft Excel SUMX2MY2 function returns the sum of the difference of squares between two arrays.

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.