SUMSQ Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

SUMSQ is an Excel Math & Trig function. Returns the sum of the squares of the given values.

SUMSQ syntax

=SUMSQ(number1, [number2], ...)

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

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

What does the SUMSQ function do in Excel?

Returns the sum of the squares of the given values.

What is the syntax of SUMSQ in Excel?

The syntax is =SUMSQ(number1, [number2], ...). number1: The first number or range; number2: An additional number or range (optional).

Where can I practice SUMSQ online for free?

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