Quick Navigation
SUM Function - Add Numbers Effortlessly in Excel
Summary
The SUM function is Excel's essential tool for totaling numeric values from individual cells, ranges, or combinations. Perfect for quick calculations, financial summaries, and data aggregation.
Syntax
SUM(number1, [number2], ...)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| number1 | Number, Range or Reference |
Yes | The first value or range to sum. Can be a constant, cell reference, or range like A1:A10. |
| number2, ... | Number, Range or Reference |
No | Additional values or ranges to include in the sum, up to 255 total arguments. |
Using the SUM Function
SUM excels at aggregating data across worksheets. Use it for totals, subtotals, financial summaries, inventory counts, and performance metrics. Combine with conditional functions like SUMIF for targeted calculations.
Common SUM Examples
Basic Range Sum
=SUM(A2:A10)Totals all numeric values in the range A2 through A10, ignoring any text entries.
Multiple Ranges
=SUM(A2:A10, C2:C10)Adds values from two separate ranges - column A and column C.
Mixed Values and Ranges
=SUM(100, B5, C2:C10)Combines constant 100, single cell B5, and range C2:C10.
Time Duration Total
=SUM(A1:A5)*24Sums time values and converts to total hours by multiplying by 24.
Frequently Asked Questions
Common Errors and Solutions
#VALUE!
Cause: All arguments contain text or incompatible data types.
Solution: Ensure at least one numeric value exists. SUM ignores text but needs numbers to work.
#REF!
Cause: Referenced cells were deleted.
Solution: SUM usually prevents this by using ranges. Avoid individual cell references in large sums.
Incorrect total
Cause: Hidden rows or filtered data included.
Solution: Use SUBTOTAL instead of SUM for visible cells only.
Time shows as decimal
Cause: Time values summed without *24 conversion.
Solution: Format result cell as time or multiply by 24 for hours.
Notes
- Most popular Excel function with perfect 10/10 popularity rating
- Use Alt+= for quick SUM of contiguous ranges
- SUM skips empty cells, text, and logical values (TRUE/FALSE)
- Essential building block for dashboard totals and reports
- Works in all Excel versions including Excel 2007+
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365, Google Sheets
Not available in:
Content last reviewed: December 11, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+