How to Add Numbers in Excel With the SUM Formula: A Guide

Formulas & functions · Updated November 20, 2026

To add a range in Excel, select the cell where you want the total and enter =SUM(B2:B4). If B2 contains 4, B3 contains 7, and B4 contains 9, the result is 20 because 4 + 7 + 9 = 20. Press Enter to calculate it. The SUM function is a quick way to total a column, row, or selection of cells, and it updates the answer when the included numbers change.

The instructions below are for Microsoft Excel for Microsoft 365 on Windows. You can type the same SUM formulas in Excel for Mac and Excel for the web. Buttons and ribbon layouts can vary slightly between those versions, so entering a formula directly is a reliable option in all three.

What You’ll Need

  • An Excel workbook with numbers you want to add. These can be in a column, a row, or separate cells.
  • A blank cell for the total. Choose a cell outside the numbers you are adding so the result does not become part of its own calculation.
  • Basic familiarity with selecting a cell and typing. No add-in or special setting is required.

Step-by-Step

  1. Open the worksheet and identify the values. Find the cells containing the numbers you want to total. Check that the values are in the expected locations and that there are no headings or unrelated figures within the range. For example, if monthly amounts are listed in cells B2 through B6, note those exact first and last cells. A range is written with a colon between its endpoints, so the range includes both B2 and B6 and every cell between them.
  2. Choose where the answer should appear. Click a blank cell below or beside the values. If the amounts are in B2:B6, B7 is a natural place for the result. Keep the total outside the range being summed. If you put the formula inside the range, Excel may report a circular reference because the formula would try to include its own answer in the total.
  3. Type the SUM formula. With numbers in B2:B6 and the result intended for B7, enter =SUM(B2:B6) in B7. Start with an equals sign, type SUM, and put the cell range inside parentheses. The colon means include every cell from B2 through B6. You can type the formula in the cell itself or in the formula bar after selecting B7.
  4. Confirm the formula. Press Enter on Windows. Excel calculates the total and leaves B7 selected. If B2:B6 contain 10, 15, 8, 12, and 5, the answer is 50 because 10 + 15 + 8 + 12 + 5 = 50. The formula remains in the cell even though Excel displays the calculated answer on the worksheet. Click B7 and look at the formula bar if you want to check or edit it.
  5. Use AutoSum if you would rather not type the range. Select the blank cell below a column of numbers, then choose Home > Editing > AutoSum on the Windows ribbon. Excel inserts a SUM formula and highlights the range it thinks you want to add. Check the outlined cells before continuing. If the selection is right, press Enter; if it is wrong, select the intended cells or edit the range in the formula before pressing Enter. AutoSum is also available from the Formulas tab. In Excel for Mac or the web, use the AutoSum button if it appears on the Home or Formulas tab; otherwise, enter the formula directly.
  6. Add numbers across a row when needed. SUM works the same way horizontally. With numbers in C3:G3 and the result intended for H3, enter =SUM(C3:G3) in H3. If those cells contain 2, 4, 6, 8, and 10, the result is 30. This is useful for totaling a row of weekly figures or categories.
  7. Add selected cells that are not next to each other. You can list separate cells as arguments, separated by commas. With amounts in B2, B4, and B7, and the total intended for B9, enter =SUM(B2,B4,B7) in B9. If those three cells contain 12, 8, and 5, the result is 25. The formula includes only the listed cells, so it will not include other values between them.
  8. Check the result and save your work. Compare the displayed total with a quick manual check or a calculator, especially if it is a report or a large set of figures. If the values change later, the SUM result recalculates automatically as long as calculation is set to Automatic. Save the workbook with Ctrl+S on Windows. On Mac, use Command+S; Excel for the web saves changes to the cloud automatically when connected.

On Windows, Alt+= is a keyboard shortcut for AutoSum in many Excel layouts. Select the cell where you want the total before using it, then review the suggested range before accepting. If the shortcut does not work on your keyboard or in your version, use the ribbon button or type the formula instead. Avoid relying on a keyboard shortcut when you have not checked which cells Excel selected.

Common Mistakes

  • Selecting the wrong range: A formula can be syntactically correct but still miss the first or last value. Check the highlighted range in the formula bar or click the formula cell and inspect the references. AutoSum can guess incorrectly when blank rows or nearby numbers interrupt the layout.
  • Putting the total inside the range: If the answer cell is part of the cells being added, Excel cannot calculate a normal total without referring to itself. Place the result just beyond the range, or adjust the range so it excludes the result cell.
  • Typing a formula without the equals sign: Excel treats an entry that does not start with an equals sign as ordinary text in many cases. If the cell displays the typed formula instead of a number, check that the first character is an equals sign and that the cell is not formatted as Text.
  • Using the wrong separator between separate cells: In a standard English-language Excel setup, commas separate arguments, as in the example above. Regional settings can affect formula separators, so some installations may expect semicolons. If Excel flags a comma as invalid, follow the separator style used by formulas in your installation. Range notation with a colon remains the normal way to refer to cells between two endpoints.
  • Assuming visible values are numeric: Numbers stored as text may not be added as expected. This can happen after copying data from a website or importing a file. A green error indicator or left-aligned number may be a clue, though formatting alone is not a definitive test. Check the cell contents and convert text-formatted numbers to numeric values if needed.
  • Expecting SUM to ignore hidden rows: SUM includes numeric values in hidden rows within its range. Hiding a row does not remove its value from the total. If the goal is a total that changes based on filtered or hidden rows, choose a function designed for that task rather than assuming SUM will exclude them.
  • Including a heading or unrelated cell: Text headings are generally ignored by SUM, but including extra numeric cells can inflate a total. Keep the range narrow and check every included row, especially when the worksheet has subtotals or several tables close together.

Tips

  • Use a range for a continuous list. A reference such as B2:B100 is easier to review than listing every individual cell. It also includes new numbers entered within that range, though it will not automatically expand to include rows added below the last endpoint.
  • Copy a total formula carefully. When you fill or copy a formula to another location, Excel normally adjusts relative references to match the new position. After copying, check the selected range so the new total covers the intended values.
  • Format the answer for readability. Select the total cell and use the number-format controls on the Home tab to display a number of decimal places, a thousands separator, or a currency format when appropriate. Formatting changes how the result looks, not the underlying calculation.
  • Use a clear label. Put a label such as Total next to the result, rather than inside the range being added. Labels make worksheets easier to scan and help other people understand what the number represents.
  • Keep source values and totals distinct. A consistent layout, such as values in one column and the total immediately below, makes it easier to review formulas and spot accidental inclusions. For longer sheets, consider using an Excel table so new rows and related formulas are easier to manage.
  • Check calculation settings if changes do not appear. In Excel for Windows, Automatic calculation is managed from Formulas > Calculation Options > Automatic. If the workbook is set to Manual, Excel may not recalculate immediately when an input changes. Choose Automatic or recalculate the workbook when appropriate.

Troubleshooting

The cell shows the formula instead of the answer. First, make sure the formula begins with an equals sign. If it does, select the cell, change its number format from Text to General using Home > Number Format, then re-enter the formula. Press F2 and then Enter on Windows to edit and confirm the existing entry. On a Mac, use the equivalent cell-editing key for your keyboard or simply click the formula bar and confirm the entry again.

The answer is zero or smaller than expected. Check that the reference covers the correct cells and that the values are numbers rather than text. Double-click or inspect a questionable cell, remove an accidental leading apostrophe if present, and convert imported text values to numbers. Also look for negative values, which reduce a total, and blank cells, which do not add anything.

Excel displays an error or rejects the entry. Check that the parentheses are balanced and that the range uses a colon between its starting and ending cells. For separate cell arguments, use the separator your regional settings require. If you see a circular-reference warning, move the result outside the range or remove the result cell from the range.

The total does not change after editing a value. Confirm that you changed a cell included in the formula. Then check Formulas > Calculation Options on Windows and make sure Automatic is selected. If the workbook is in Manual mode, press F9 to recalculate on Windows. Excel for Mac has calculation options on its Formulas tab; Excel for the web generally recalculates automatically when a formula or input changes.

The total includes rows that are hidden or filtered out. That is normal for SUM: it includes numeric cells in the specified range even when their rows are hidden. If you need the result to respond to filtering, use a function intended for filtered lists and confirm that its behavior matches your worksheet before replacing the formula.

Frequently Asked Questions

What is the basic SUM formula in Excel?
For values in B2:B10, with the answer placed outside that range, enter =SUM(B2:B10). SUM adds the numeric values in the specified cells.

Can I add cells that are not next to each other?
Yes. List the individual cell references inside SUM and separate them with commas in a standard English-language setup. The result includes only those selected cells. If your regional settings use a different argument separator, use the one Excel accepts.

Does SUM include blank cells or text?
Blank cells and ordinary text within a referenced range do not contribute to the numeric total. Numbers stored as text may also be ignored, so convert those entries to numeric values if the total is incomplete.

Can I use SUM for numbers in different columns?
Yes. You can use separate ranges as arguments. With values in B2:B4 and D2:D4, and the result placed outside both ranges, enter =SUM(B2:B4,D2:D4). If B2:B4 total 15 and D2:D4 total 24, the result is 39.

Will the total update when I change a number?
Yes, if the changed cell is within the formula’s range and Excel is recalculating automatically. A Manual calculation setting can delay the update until you recalculate.

How do I add only visible rows?
SUM includes hidden rows, so it is not the right choice when hidden or filtered-out values must be excluded. Use a visibility-aware function suited to your worksheet and check its options, especially if you have manually hidden rows as well as filtered rows.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.