To add numbers in Excel, enter a formula in the cell where you want the total. With values in B2:B6, select B7 and type =SUM(B2:B6), then press Enter. For just two cells, with numbers in B2 and B3, you can instead enter =B2+B3. SUM is usually the clearest choice for a range; the plus sign is handy for a few individual values.
The steps below are for Microsoft Excel for Microsoft 365 on Windows. You can use the same formulas in Excel for Mac and Excel for the web, although the ribbon layout and keyboard shortcuts can differ slightly.
What You’ll Need
- An Excel workbook with numbers you want to add. The numbers can be in a column, a row, or separate cells.
- A blank cell for the result. Choose one outside the range you plan to add so the formula does not include its own result.
- A basic understanding of the cell addresses shown in the worksheet. For example, B2 means column B, row 2.
Step-by-Step
- Arrange and check the numbers. Put the values you want to total in a clear row or column. For example, you might list daily costs in B2 through B6 and put a label such as Total in A7. Check that each value is really a number: numbers are usually right-aligned by default, while text is often left-aligned. Formatting can change alignment, so if you are unsure, click a cell and inspect its value in the formula bar. Avoid putting explanatory words inside the range you plan to sum.
- Select the cell for the answer. Click the blank cell where you want the total to appear. If the values are in B2:B6, B7 is a convenient result cell. The formula can be placed elsewhere, but keeping it near the data makes the sheet easier to read. Do not put it inside the range being added; a formula in B4 that sums B2:B6 would include itself and can trigger a circular reference warning.
- Enter a SUM formula for a range. With the values in B2:B6 and the result cell B7, type
=SUM(B2:B6)into B7. The colon means include every cell from B2 through B6. Press Enter to finish. If the five cells contain 12, 8, 15, 5, and 10, the result is 50. Excel displays the calculated total in B7 while the formula remains available in the formula bar when you select that cell. - Use the plus sign for a small number of cells. When you need to add two or three separate cells, enter a formula that names each cell. With 12 in B2 and 8 in B3, select B4 and type
=B2+B3. Press Enter; the result is 20. You can add more individual cell references by putting another plus sign between them. For a long list or a continuous range, SUM is easier to check and maintain. - Insert SUM with AutoSum if you prefer not to type the range. Select the blank cell below a column of values, such as B7 when the numbers are in B2:B6. On Windows, press Alt+=, or choose Home > AutoSum in the Editing group. Excel proposes a range and shows the formula before you confirm it. Check that the outlined cells are exactly the ones you mean to add, then press Enter. In Excel for Mac or Excel for the web, use the AutoSum button on the Home tab if the Windows shortcut is not available or differs in your setup.
- Check the result and the formula. Compare the displayed total with a quick mental estimate. Click the answer cell to see the formula bar; the formula should start with an equals sign and refer to the intended cells. If a value changes, Excel normally recalculates the total automatically. You can also select the result cell and press F2 to edit the formula, then press Enter to accept the change.
- Add separate ranges when the values are in different places. If one group is in B2:B6 and another is in D2:D6, put the total in a cell outside both ranges. With those cell locations, enter
=SUM(B2:B6,D2:D6). This adds both groups and returns 100 if each range contains the five example values 12, 8, 15, 5, and 10. The comma separates the arguments; the colon still marks the first and last cell within each range. - Copy a formula for other totals when appropriate. If each row has a pair of values and you want a total per row, enter a formula in the first result row, then use the fill handle, the small square at the lower-right corner of the selected cell, to drag the formula down. With values in B2 and C2 and the row total in D2, enter
=SUM(B2:C2). When filled to D3, Excel adjusts the references to B3:C3 automatically. Check a copied result or two to make sure the ranges shifted as intended.
Common Mistakes
Leaving out the equals sign: Excel needs an equals sign at the start to treat an entry as a formula. Without it, the cell may show the characters you typed instead of calculating a total.
Selecting the wrong range: A range that stops one row too early leaves out a value; one that extends too far may include a subtotal or unrelated number. Before confirming, inspect the cell references or the colored outline Excel shows while you edit.
Including the result cell in its own total: If the formula cell is part of the range it adds, Excel may report a circular reference. Keep the result just above, below, or beside the data, and confirm the referenced range excludes it.
Typing numbers as text: A value imported with an apostrophe or stored as text may not be included as expected in a SUM calculation. Look for a warning indicator or inconsistent alignment, and check whether the cell is actually numeric before relying on the total.
Replacing a formula with a typed answer: If you type 50 directly into the result cell, it will not update when the inputs change. Keep the formula in the cell and use a separate cell for any note or manually entered adjustment.
Using the wrong list separator: Excel installations with certain regional settings may display a semicolon rather than a comma between function arguments. If a formula with multiple arguments is rejected, follow the separator Excel uses in its own examples or when you insert a function. A simple one-range SUM formula does not use an argument separator.
Tips
Use SUM for most totals because its purpose is immediately recognizable and it is easy to expand when you add more values. A range reference such as B2:B6 includes every cell between its endpoints. If you add a new value at the bottom, update the range or place the new row within an existing table or range arrangement that Excel will include in the total.
Give the result a useful label, such as Monthly total, and apply a suitable number format from the Home tab. Formatting changes how a value looks, not the underlying calculation. For instance, a currency format displays a currency symbol, but it does not convert text into a number or change which cells the formula adds.
Keep formulas and source values in separate cells. That makes it easier to trace a total and reduces the risk of overwriting inputs. If you are building several similar totals, copy the formula and verify the references rather than retyping each one; Excel adjusts ordinary relative references as the formula moves.
For a quick check, add the values another way or compare the total with a rough estimate. If you expect a result around 100 but see 1,000, inspect for a misplaced decimal, an extra zero, or an unintended cell in the selected range. A second check is especially useful before sharing a workbook or using the result in another calculation.
Troubleshooting
The cell displays the formula instead of the answer. First check that the entry begins with an equals sign and that the cell is not formatted as Text. Select the cell, change its number format to General from Home > Number Format, then press F2 and Enter to make Excel interpret the entry again. Also check whether Show Formulas is on; press Ctrl+` on Windows to toggle it. On a Mac, use the equivalent Show Formulas command if that shortcut differs in your keyboard setup.
The answer is zero or smaller than expected. Check that the formula refers to the right cells and that the source entries are numbers rather than text. Select a suspicious input and inspect the formula bar. If values came from a website or another file, extra spaces or an apostrophe may be present. Re-enter a test value as a number or use Excel’s warning options to convert text to numbers when offered.
Excel shows a circular reference warning. The formula may be referring to its own cell, directly or through another formula. Move the total outside the range, then edit the reference so the formula includes only the intended input cells. Do not enable iterative calculation just to hide a circular reference unless the workbook is intentionally designed to use iterative calculations.
The result does not change after editing an input. Confirm that the changed cell belongs to the formula’s range. If it does, check Formulas > Calculation Options and choose Automatic if the workbook is set to Manual. You can recalculate the workbook with F9 on Windows. In Excel for Mac or the web, use the calculation commands available in that version if the Windows shortcut is different.
A formula is rejected as an error. Check for a missing parenthesis, colon, or equals sign, and make sure cell references are spelled correctly. For formulas with multiple separate ranges, check the list separator expected by your regional settings. Also confirm that the formula was entered into a normal worksheet cell rather than a text box.
Frequently Asked Questions
Is SUM better than using the plus sign?
For a continuous range or a longer list, SUM is usually more readable and easier to update. The plus sign is perfectly valid for adding a few individual cells or values. Choose the method that makes the references clear to someone reviewing the workbook.
Can I add numbers that are not next to each other?
Yes. A SUM formula can include multiple ranges or individual cell references separated by the argument separator used in your Excel settings. Check the references carefully so you do not accidentally add a heading, an old subtotal, or a value outside the intended group.
Will a total update when I change a number?
Normally, yes. Excel recalculates formulas automatically when an input changes. If the displayed answer stays the same, make sure the edited cell is included in the formula and that calculation mode is Automatic rather than Manual.
Can I use a formula to add an entire column?
Yes, but consider whether the column contains other numbers, such as a separate total or notes encoded as numbers. Adding an entire column can be convenient when the data is clean, while a specific range is safer when the sheet contains unrelated values. Keep the result outside any column range that would include its own formula.
Does this work in Excel for Mac and Excel for the web?
Yes. SUM and plus-sign formulas work in current Excel for Mac and Excel for the web as well as Microsoft 365 for Windows. Ribbon placement and keyboard shortcuts can vary, so use the on-screen AutoSum command if the Windows instructions do not match your version.
Why is a blank cell not changing the total?
SUM ignores blank cells, so a blank contributes zero to the result. If you expected a value, check that it was entered into a cell inside the formula’s range and that it was not accidentally deleted or stored elsewhere.
Related
- Export to CSV vs Excel: Which Format Should You Choose?
- Extract Data from Google Maps to Excel: Practical Options
- Export Excel to Word: Methods and Formatting Tips
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- How to Filter Highest to Lowest in Excel: A Quick GuideTo show the largest values first in Excel, open the filter arrow on the column you want to…
- COUNTIF Excel Range: What to Select and How It WorksIn Excel, the range in COUNTIF is the group of cells the function checks; the basic form is…
- Excel Formula Not Calculating Until You Press Enter?If an Excel formula updates only after you press Enter, first check whether calculation is set to Automatic:…
- Excel Midpoint of Dates: Formula and ExamplesTo find the midpoint between two dates in Excel, put the earlier date in A2 and the later…
- How to Concatenate Names in Excel With a Space EasilyTo concatenate first and last names in Excel with a space, put the first name in A2 and…
- Dynamic Array Formulas in Excel: How They WorkA dynamic array formula in Excel returns multiple results that spill automatically into neighboring cells, so one formula…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.