Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
SUMSQ
SUMSQ squares each number in its arguments and then sums all the squared values. You can pass individual numbers, cell references, or ranges. It is commonly used in statistical formulas such as sum of squared deviations, and in engineering or physics computations where the Euclidean norm or least-squares values are needed.
Excel
=SUMSQ(B2:B5)Google Sheets
=SUMSQ(B2:B5)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Label | Value |
| A | 3 |
| B | 4 |
| C | 5 |
| D | 2 |
=SUMSQ(B2:B5)→54
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1B2:B5 is the range of numbers — SUMSQ squares every value in this range.
- 2Each squared value is added together to produce the total sum of squares.
- 3You can also pass individual values: =SUMSQ(3,4) returns 25 (9+16).