SUMX2MY2 Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

SUMX2MY2 is an Excel Math & Trig function. Sums the difference of squares of two corresponding ranges.

SUMX2MY2 syntax

=SUMX2MY2(array_x, array_y)

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

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

What does the SUMX2MY2 function do in Excel?

Sums the difference of squares of two corresponding ranges.

What is the syntax of SUMX2MY2 in Excel?

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

Where can I practice SUMX2MY2 online for free?

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