SUMX2PY2 Function in Excel: Syntax, Examples and Free Practice
SUMX2PY2 is an Excel Math & Trig function. Sums the total of squares of two corresponding ranges.
SUMX2PY2 syntax
=SUMX2PY2(array_x, array_y)
Arguments
array_x: The range of x-valuesarray_y: The range of y-values
When to use SUMX2PY2
SUMX2PY2 is used in financial models and engineering-style calculations where precise numeric work is needed.
Practice SUMX2PY2 online, free
Open the live Excel-style spreadsheet and try SUMX2PY2 yourself. No Excel install or sign-up needed to start.
Practice SUMX2PY2 now →More Math & Trig functions
Frequently asked questions
What does the SUMX2PY2 function do in Excel?
Sums the total of squares of two corresponding ranges.
What is the syntax of SUMX2PY2 in Excel?
The syntax is =SUMX2PY2(array_x, array_y). array_x: The range of x-values; array_y: The range of y-values.
Where can I practice SUMX2PY2 online for free?
Open the free live spreadsheet on Cellgrids and try SUMX2PY2 yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Math and Trig functions · Excel case studies · Excel tutorials · Excel shortcuts