SUMSQ Function
Returns the sum of the squares of its arguments.
Category
Math & Trig
Available in
All versions, Microsoft 365
Returns
A number
Want to practice SUMSQ in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
SUMSQ squares each number and adds them up: SUMSQ(3, 4) is 9 + 16 = 25.
It appears inside variance and distance calculations.
Syntax
=SUMSQ(number1, [number2], …)
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number1 | Yes | A number, cell or range. |
| number2, … | Optional | Up to 254 more. |
Examples
Example 1 — Sum of squared errors
Forecast errors for four weeks, squared and added.
C2fx=SUMSQ(B2:B5)
| A | B | C | |
|---|---|---|---|
| 1 | Week | Error | Total squared |
| 2 | 1 | 3 | 38 |
| 3 | 2 | -2 | |
| 4 | 3 | 5 | |
| 5 | 4 | 0 |
=SUMSQ(B2:B5) Explain
Common mistakes
- Text in ranges is ignored. Only numbers are squared.
Notes
- Related functions: SUMX2MY2, SUMX2PY2, SUMXMY2, SUMPRODUCT.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.