SUMXMY2 Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

SUMXMY2 is an Excel Math & Trig function. Sums the squares of differences between two corresponding ranges.

SUMXMY2 syntax

=SUMXMY2(array_x, array_y)

SUMXMY2 is used in financial models and engineering-style calculations where precise numeric work is needed.

Open the live Excel-style spreadsheet and try SUMXMY2 yourself. No Excel install or sign-up needed to start.

What does the SUMXMY2 function do in Excel?

Sums the squares of differences between two corresponding ranges.

What is the syntax of SUMXMY2 in Excel?

The syntax is =SUMXMY2(array_x, array_y). array_x: The range of x-values; array_y: The range of y-values.

Where can I practice SUMXMY2 online for free?

Open the free live spreadsheet on Cellgrids and try SUMXMY2 yourself. No Excel install is needed and you can start without signing up.