To add values in Excel, use the SUM function: if the numbers are in cells A1 through A5, enter =SUM(A1:A5) in an empty cell and press Enter. You can also select the cells and choose Home > AutoSum (Σ); Excel will suggest a total formula you can confirm.
What a basic sum does
A sum is the total of two or more numbers. In Excel, a formula calculates that total from values you enter directly, cell references, or a range of cells. The result updates when the referenced numbers change, which is one reason a spreadsheet formula is more useful than typing a total by hand.
For example, suppose A1 through A5 contain 12, 8, 15, 5, and 10. With those values in A1:A5, enter =SUM(A1:A5) in A6; the result is 50. The colon means the formula includes every cell from A1 through A5, including both endpoints.
In a typical worksheet, put labels in one column, amounts in another, and a total beneath the amounts. For instance, A1:A4 might list product names and B1:B4 their quantities. Place the total in B5, not among the values being added. This arrangement makes the formula easier to read and reduces the chance that the total itself is included in its own calculation.
How to enter a SUM formula
To add a continuous block of cells, click the cell where you want the answer, type an equals sign, the function name, and the range in parentheses. Press Enter to calculate it. If the values are in B2:B8 and the total belongs in B9, enter =SUM(B2:B8) in B9. If the cells contain 3, 4, 5, 6, 7, 8, and 9, the result is 42.
You can type a formula or build it by selecting cells with the mouse. After typing =SUM(, drag across the range, type the closing parenthesis, and press Enter. Excel displays the formula in the formula bar when you select the result cell. The worksheet cell normally displays the calculated value instead.
For a few separate cells that do not form one continuous block, list their references separated by commas. If A1, A3, and A5 contain 10, 20, and 30, enter =SUM(A1,A3,A5) in A6; the result is 60. You can also combine a range and individual cells. With A1:A4 containing 1, 2, 3, and 4, and C1 containing 10, enter =SUM(A1:A4,C1) in C2; the result is 20.
Use AutoSum for a quick total
AutoSum is a convenient way to insert a SUM formula without typing the whole range. Select the empty cell directly below a column of numbers or directly to the right of a row of numbers, then choose Home > AutoSum (Σ). Excel outlines the range it believes you want to add. Check that outline before pressing Enter; you can adjust the selection if it misses a value or includes an unwanted cell.
On Windows, Alt+= is the keyboard shortcut for AutoSum. On a Mac, use the AutoSum button if the keyboard shortcut is unfamiliar or differs with the keyboard layout. AutoSum is a shortcut for creating a formula, not a separate kind of calculation. After you confirm it, the cell contains an ordinary SUM formula that you can edit like any other.
AutoSum works best when the data is arranged in a clear, uninterrupted row or column. Blank rows, text entries, or nearby totals can affect what Excel suggests. It is not a substitute for checking the formula: confirm that the highlighted references include exactly the values intended.
Add numbers directly or use SUM?
For a short calculation, Excel can add individual numbers using the plus sign. Enter =12+8+15 in a blank cell to get 35. This is valid when the numbers are fixed and the calculation is small, but values typed into the formula are harder to update than values kept in worksheet cells.
If the numbers are in A1, A2, and A3, enter =A1+A2+A3 in A4 to add those three references. This works, but a SUM formula is usually easier to maintain when you have a range. With values in A1:A3, =SUM(A1:A3) in A4 also returns their total, and you can extend the referenced range if your data grows.
A practical rule is to use plus signs for a small, fixed arithmetic expression and SUM for a list, range, or total that may change. Either approach can be correct. The important point is to make sure the formula references the intended cells and that a future editor can tell what it includes.
Sum a row, multiple ranges, or a growing list
SUM is not limited to vertical columns. If Monday through Friday values are in B2:F2 and you want the total in G2, enter =SUM(B2:F2) in G2. If those values are 4, 6, 3, 7, and 5, the result is 25. The same colon notation applies across a row or down a column.
For separate blocks, include each range as an argument. If January amounts are in B2:B6 and February amounts are in D2:D6, put =SUM(B2:B6,D2:D6) in D7; when the two ranges total 100 and 125 respectively, the result is 225. Commas separate arguments in the formula syntax used by standard English-language Excel installations. Regional settings can use different list separators, so an installation configured for another locale may display a semicolon instead.
For a list expected to grow, you can reference an entire column. With values in B2:B20, enter =SUM(B:B) in D1; if the values total 190, the result is 190. Do not put this formula in column B, because it would include its own cell and create a circular reference. A bounded range is often clearer and can avoid including unrelated numbers elsewhere in the column.
Another option for an expanding dataset is an Excel table. Select the data and choose Insert > Table, then use the table’s Total Row feature to calculate a column total. Table references can adjust when rows are added, although their formula appearance differs from ordinary cell references. For a simple worksheet, a clearly sized range is usually sufficient.
What SUM includes—and common mistakes
SUM adds numeric values in referenced cells. It ignores blank cells and text in a referenced range, so a label such as Total is not added as a number. A number stored as text may also be ignored, which can make a result lower than expected. If an amount looks numeric but is left-aligned or marked with a warning indicator, check whether Excel has stored it as text.
Other frequent problems include selecting the wrong range, omitting the first or last value, or putting the total inside the range it is meant to total. A formula such as =SUM(B2:B10) in B10 includes its own cell and can produce a circular-reference warning. Put the result outside the referenced range, such as in B11, or adjust the range to exclude the result cell.
- Formula is shown instead of a result: Check that the cell is not formatted as Text. Change the format to General, then edit the formula and press Enter. Also check whether Show Formulas is enabled.
- The result is zero or too small: Inspect the source cells for numbers stored as text, and verify the range includes every intended value.
- Excel displays an error: Check for a missing closing parenthesis, a misspelled function, or a separator that does not match your regional settings.
- The answer does not change after editing values: Check Formulas > Calculation Options and make sure calculation is set to Automatic. In Manual mode, Excel may need a recalculation command.
Formatting can also confuse readers. A cell might display a rounded number, such as 10, even though its stored value is 9.6. SUM uses the underlying value, not merely the rounded display. If visible rounding is part of the required calculation, use an appropriate rounding formula deliberately rather than assuming the displayed digits are the only ones being added.
SUM compared with other ways to total data
For ordinary additions, SUM is the standard starting point. If you need to add values only when they meet a condition, use SUMIF for one condition or SUMIFS for multiple conditions. For example, a sales list may need a total for one region rather than every region. These functions require a criteria range and a condition, so they solve a different problem from adding every number in a simple range.
When a dataset is filtered, a plain SUM still adds all numeric values in its referenced range, including rows hidden by a filter. If the goal is a total that responds to filtered or manually hidden rows, SUBTOTAL can be more appropriate. Its function number determines the calculation; for addition, the commonly used code is 9, while 109 also ignores manually hidden rows. Check which rows should count before choosing it.
These alternatives are not upgrades that should replace SUM in every workbook. Use SUM for an uncomplicated total, SUMIF or SUMIFS when conditions control what counts, and SUBTOTAL when visibility or filtering should affect the result. Choosing the simplest formula that expresses the intended calculation makes the sheet easier to check.
Check and maintain your total
After entering a total, verify it using a small independent check, especially when the result matters to a report. Select the referenced cells and look at Excel’s status bar, which can show Sum when numeric cells are selected. The status-bar value is a quick comparison, not a replacement for a saved formula.
When working with recurring lists, keep source values together and put the total in a clearly labeled separate row. Avoid inserting unrelated numbers in the same column if you use a whole-column reference. If other people will use the workbook, consider labeling the total and using consistent number formats so they can distinguish data from calculations.
For a formula that needs to be copied down several rows, use relative references carefully. For example, a formula referring to B2:B5 will shift to B3:B6 when copied one row down. That is often desirable for per-item totals, but not if every formula should use the same fixed input range. In that case, absolute references marked with dollar signs can lock the range; check the resulting references after copying.
Frequently Asked Questions
What is the basic sum formula in Excel?
Use =SUM(A1:A5) to add the values in cells A1 through A5. Replace the example range with the cells containing your numbers.
How do I sum a column in Excel?
Put the result below the numbers, select Home > AutoSum (Σ), check the suggested range, and press Enter. Or type a SUM formula that names the range, such as =SUM(B2:B10).
Can I add cells that are not next to each other?
Yes. List the cell references as separate SUM arguments, as in =SUM(A1,A3,A5). You can also include multiple ranges in one formula.
Why is Excel not adding some numbers?
The cells may contain numbers stored as text, or the formula may not cover the full range. Check the cell values and formula references, and confirm that the source cells contain numeric values.
Does SUM include hidden or filtered rows?
A normal SUM includes numeric values in its referenced range even when rows are hidden by a filter. Consider SUBTOTAL if the result should change with filtered visibility, and choose the appropriate function number for how hidden rows should be handled.
Is SUM better than using plus signs?
Both can add values. Plus signs are fine for a few fixed numbers, while SUM is generally clearer and easier to maintain for cell ranges and longer lists.
Related
- Excel Export CSV Pipe Delimited: Steps and Options
- Excel Export to CSV with Semicolons
- Excel Export CSV Comma or Semicolon? Change the Delimiter
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Solver Sensitivity Report: How to Read ItAn Excel Solver sensitivity report shows how changes to a linear optimization model’s objective coefficients and constraint limits…
- How to Merge Two Tables in Excel Using Power QueryTo merge two tables in Excel with Power Query, load each table into Power Query, choose Home >…
- How to Put X in an Excel Cell and Fill More Cells QuicklyTo put an x in an Excel cell, select the cell, type x (or X for uppercase), and…
- Microsoft Word: Remove a Next Page Section BreakTo remove a Next Page section break in Microsoft Word for Microsoft 365 on Windows, select the break…
- Excel Table with Subcategories: Setup and ExamplesYes. To make an Excel table with subcategories, put the main category and its subcategory in separate columns,…
- Google Sheets Merge Cells Shortcut and Safe AlternativesGoogle Sheets has no dedicated keyboard shortcut that directly merges selected cells. In a browser, select the cells…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.