SUM Function in Excel
Beginner
Adds all the numbers in a range of cells.
Syntax
=SUM(number1, [number2], ...)Example
Use Case
Calculate the total sales for the month.
Common Errors to Avoid
- Including text or empty cells returns 0 instead of error
- Hidden rows are still included in SUM calculation
- Forgetting to use absolute references when copying formulas
Pro Tips
Use range references (A1:A10) instead of individual cells for better maintainability. For visible cells only, use SUBTOTAL(9, range) instead. Double-check that your range includes all intended cells.
Need help with this formula?
Our AI Formula Generator can write this for you instantly.
Try AI Formula Generator →