Math & Trig
All versions
◉ 30 views
=SUMSQ()
Returns the sum of the squares of the arguments.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=SUMSQ(number1, [number2], ...)
Hover argument names in the table for details.
Output typeNumber
Popularity15 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =SUMSQ() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
number1 |
Number | Required | , number2, ... Number1 is required. Subsequent numbers are optional. There can be as many as 255 arguments for which you want the sum of the squares. |
instead |
Range | Optional | of comma-separated arguments, you can use a single array or a reference to an array. |
▣ Examples
Sum of the squares of 3 and 4 (25)
=SUMSQ(3, 4)
Result:
25
§ Remarks
- Arguments can be > numbers > names, arrays, or references containing numbers.
- The count includes numbers, logical values, and text representations of numbers typed into the list.
- If an argument is an array or reference, only numbers in that array or reference are counted. This function will ignore empty cells, logical values, text, or error values in the array or reference.
- Errors will occur from > arguments that are error values > text that cannot be translated into numbers
✦ Tips
- Arguments can be > numbers > names, arrays, or references containing numbers.
- The count includes numbers, logical values, and text representations of numbers typed into the list.
- If an argument is an array or reference, only numbers in that array or reference are counted. This function will ignore empty cells, logical values, text, or error values in the array or reference.
- Errors will occur from > arguments that are error values > text that cannot be translated into numbers
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!