Quick Answer
SUM Function
SUM calculates the sum of numeric values in a range.
✓ Excel✓ Google SheetsExcel All versions
Syntax
SUM
(number1, [number2], ...)
Parameters
| Parameter | Description | Required |
|---|---|---|
| number1 | The first number, cell reference, or range to add. | Required |
| number2 | Optional additional numbers, cell references, or ranges to add. | Optional |
Basic Example
Sum values in a column
=SUM(A1:A10)Result500
Adds all numeric values in cells A1 through A10.
Advanced Examples
Example 1: Sum across multiple sheets
Multi-sheet calculationsSum the same range across multiple worksheets
=SUM(Sheet1:Sheet3!A1:A10)Result: 1500
Adds values from A1:A10 across Sheet1, Sheet2, and Sheet3.
Example 2: Conditional sum with SUMIF
Filtered totalsSum only values that meet a condition
=SUMIF(A1:A10, ">100")Result: 350
SUMIF adds only values greater than 100.
How SUM Works
SUM iterates through each cell in the specified range, adds up numeric values, and ignores text, blank cells, and error values.
1
Select output cell
Choose where the sum should appear.
2
Enter formula
Type =SUM(range).
3
Press Enter
The result shows the total sum.
Important Notes & Limitations
SUM ignores text and blank cells.
For conditional summing, use SUMIF or SUMIFS.
Common Errors & Fixes
#VALUE!Text or error values in the rangeFix: Check for non-numeric values or use SUMIF to exclude errors.
Download Practice File
SUM
sumPractice SUM with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the SUM function. Works in both Excel and Google Sheets.
Works in Google SheetsCompatible with ExcelIncludes exercises
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps
Related Tutorials
Frequently Asked Questions
Can SUM handle negative numbers?
Yes, SUM correctly adds positive and negative numbers.
Does SUM ignore errors?
No, if any cell contains an error, SUM returns that error. Use AGGREGATE or SUMIF to ignore errors.