To add numbers in Excel, select the cell where you want the answer, type a formula that starts with an equals sign, and press Enter. For example, with the numbers in A2 and B2, enter =A2+B2 in C2 to add them. You can also use the SUM function to total a range. You need an Excel workbook and the numbers you want to add; the steps below are for Microsoft Excel for Microsoft 365 on Windows.
What You’ll Need
- An Excel workbook, either an existing file or a new blank workbook.
- The values you want to add, entered in cells. For example, you might put one number in A2 and another in B2.
- A blank cell for the answer. Keeping the result separate from the original values makes the calculation easier to review and update.
You do not need to turn on a special addition setting or install an add-in. Excel recalculates a formula when its referenced numbers change, provided calculation is set to automatic, which is the usual default.
Step-by-Step
- Enter the numbers in the worksheet. Click a cell, type a number, and press Enter. For this example, enter 12 in A2 and 8 in B2. You can use different cells and numbers in your own workbook; the formula must refer to the cells that actually contain your values. If you have labels, put them in a neighboring column, such as “First amount” in A2 and the number in B2, and adjust the formula to refer to the number cells.
- Select the cell where the total should appear. For the example with 12 in A2 and 8 in B2, click C2. The result will appear in that cell, leaving the original values in place. Check that the result cell is not one of the cells being added. Putting a formula in A2 that also refers to A2 would create a circular reference rather than a straightforward total.
- Type the addition formula. With 12 in A2, 8 in B2, and the answer intended for C2, type
=A2+B2in C2. Begin with the equals sign so Excel knows to calculate rather than display the entry as ordinary text. The plus sign tells Excel to add the values in A2 and B2. - Press Enter and check the result. In the example layout,
=A2+B2returns 20 because 12 plus 8 equals 20. Excel displays the result in C2, while the formula remains stored in that cell. Click C2 to see the formula in the formula bar. If the result is not 20, check that the two source cells contain the intended values and that the formula points to them. - Add more than two cells when needed. You can include several cell references in one formula. With 12 in A2, 8 in B2, and 5 in C2, enter
=A2+B2+C2in D2. The result is 25. Use a plus sign between every cell reference, and do not omit the equals sign at the beginning. - Use SUM for a continuous range of numbers. For a list in adjacent cells, SUM can be quicker to read and easier to extend. With 12 in A2, 8 in A3, 5 in A4, and 10 in A5, enter
=SUM(A2:A5)in A6. The answer is 35. The colon means the range includes every cell from A2 through A5. This is useful for a column of daily figures, item counts, or other values that belong in one total. - Use SUM for cells that are not next to each other. If you want to total selected cells rather than one continuous block, list their references inside SUM. With 12 in A2, 8 in B2, and 5 in D2, enter
=SUM(A2,B2,D2)in E2. It returns 25. In Excel for Microsoft 365 on Windows, commas separate the arguments in this formula. If your regional settings use a different list separator, Excel may show a semicolon as the separator when you enter formulas; follow the separator Excel expects in your installation. - Copy a formula to other rows if the same calculation repeats. Suppose each row has one value in A and another in B, starting with the values in A2 and B2. Enter
=A2+B2in C2 and press Enter. Select C2, then drag the small square at the lower-right corner of the selection (the fill handle) down through C3 and the other rows you need. Excel adjusts the relative references for each row: the formula in C3 will use A3 and B3. Check a copied result against its source row before relying on a long column of totals. - Save the workbook. Press Ctrl+S on Windows and choose a file name and location if Excel asks you to save a new workbook. On Mac, use Command+S. In Excel for the web, changes to a workbook stored in OneDrive or SharePoint are generally saved automatically, but check the save status before closing or moving on to another file.
The same basic formula-entry process works in Excel for Mac and Excel for the web: select a cell, type the formula, and press Enter or Return. Ribbon layout and some keyboard shortcuts can differ, but you do not need a special addition command. On Windows, press Enter to confirm an entry; on a Mac, Enter or Return will normally confirm it, depending on your keyboard and Excel settings.
Common Mistakes
Leaving out the equals sign. If you type A2+B2 without the initial equals sign, Excel may treat the entry as text instead of calculating it. Start the formula with =, then use the references and plus sign.
Using the wrong cell references. A formula can calculate correctly but still return the wrong total if it points to unrelated cells. Click each referenced cell in the formula bar or inspect the colored outlines Excel displays while you edit. Confirm that the references correspond to the values you intended to add.
Typing numbers into the wrong cells. If your worksheet has headings or blank rows, it is easy to assume a value is in one row when it is actually in another. Verify the column letters and row numbers at the top and left of the worksheet before writing the formula.
Confusing a range with separate cell references. In a SUM formula, a colon between two addresses means every cell in the range, while commas separate individual arguments. A range such as A2:A5 includes A2, A3, A4, and A5. If you meant to add only A2 and A5, use their two references as separate SUM arguments or join them with plus signs.
Overwriting a source value with the result. If you put the total into a cell that is also part of the calculation, the formula may create a circular reference. Keep the answer in a separate cell, or place it below or beside the values being added.
Expecting a formula to change when unrelated data changes. A formula only responds to the cells it references. If you add a new amount below a SUM range but outside its endpoints, that amount will not be included automatically. Expand the range or use a suitable table-based approach if the list will keep growing.
Tips
Use plus signs when you are adding a small number of separate values, because the formula makes each item visible. Use SUM when you are totaling a long list or a continuous block. Both approaches can give the same result; choose the one that will be easiest for you or another person to check later.
Label columns clearly, such as “Quantity,” “Extra,” and “Total.” Labels do not change the calculation, but they help you avoid adding the wrong columns. Keep labels outside the range of numeric cells you intend to sum, or make sure the range starts and ends at the correct rows.
When building a formula, you can click a referenced cell instead of typing its address. With the result cell selected, type =, click the first number cell, type +, click the second number cell, and press Enter. Excel inserts the references for you. This method is especially helpful on a wide worksheet where reading column letters is difficult.
Use the formula bar to review a result. A cell normally shows the calculated answer, not the expression that produced it. Select the cell to see the expression in the formula bar, then confirm that every reference and operator is correct. You can also double-click the cell or select it and press F2 on Windows to edit the formula directly; on Mac, the equivalent editing shortcut may depend on the keyboard and Excel settings, and clicking the formula bar is a dependable alternative.
If you will copy a calculation down many rows, test the first two rows before filling the rest. Confirm that each copied formula follows the intended pattern. A relative reference such as A2 changes to A3 when copied down one row, which is usually what you want for row-by-row addition. If you need a reference to stay fixed while copying, you can make it absolute by adding dollar signs, but that is not necessary for the basic examples above.
Keep the source values as numbers rather than adding currency symbols or other text directly to them. You can apply a number format from the Home tab if you want to display a currency symbol or decimal places. Formatting changes how a number looks, not the arithmetic stored in the cell.
Troubleshooting
The cell displays the formula instead of the answer. First check whether the cell is formatted as Text. Select it, choose Home > Number Format, and select General; then edit the formula and press Enter again. Changing the format alone may not make an existing text entry calculate until you re-enter it. Also check whether Show Formulas is on. Press Ctrl+` on Windows to toggle formula display, or use Formulas > Show Formulas. The key combination and menu presentation can vary on Mac, so use the Show Formulas command on the Formulas tab if needed.
The answer is zero or unexpectedly low. Check for numbers stored as text, which can happen after copying data from a website or another system. Look for a warning indicator in the cell or a leading apostrophe in the formula bar. Try re-entering the value as a number, or use the warning menu to convert it when Excel offers that option. Also verify that your formula includes all intended cells and that no value was entered in a different row.
You see #VALUE! or another error. Check whether a cell being added contains text that is not a number, such as a note typed into a value cell. In a direct addition formula, text in a referenced cell can cause an error. Move notes to a separate column and ensure the referenced cells contain usable numeric values. If you use SUM, remember that text in referenced cells is generally ignored, but a direct reference or an incorrectly formed expression may behave differently.
The displayed total does not update after you change a number. Select Formulas > Calculation Options and check that Automatic is selected. If the workbook is set to Manual, choose Automatic, or press F9 on Windows to recalculate. On Mac, use Formulas > Calculate Now or the available recalculation command. Also make sure the changed cell is actually included in the formula.
Excel rejects the formula as you type it. Check for a missing plus sign, a misspelled cell address, or an unmatched parenthesis in a SUM formula. If Excel reports a problem with a comma in SUM, your computer’s regional settings may require a semicolon as the list separator. Use the separator suggested by Excel’s formula autocomplete or an existing formula in the workbook.
Frequently Asked Questions
What is the simplest Excel formula for addition?
Start with an equals sign, then list the cells with a plus sign between them. With values in A2 and B2, enter =A2+B2 in another cell. It adds the values currently stored in those two cells.
Can I add numbers without using cell references?
Yes. You can type numbers directly into a formula, though references are easier to update when your data changes. With no cell references—the formula uses the literal numbers 12 and 8—enter =12+8 in a blank cell; Excel returns 20.
Should I use the plus sign or SUM?
Either works for addition. The plus sign is straightforward for a few cells, while SUM is convenient for a range or a selected set of cells. Check that the chosen range includes every value you want and excludes headings or unrelated numbers.
Can I add numbers in different worksheets?
Yes. Excel formulas can refer to cells on another worksheet, although the reference must include the sheet name. The easiest way to avoid typing the reference incorrectly is to start the formula, click the other worksheet tab, select the desired cell, and finish the formula. If a sheet name contains spaces, Excel encloses it in single quotation marks when it builds the reference.
Why does my formula show a different result after I copy it?
Excel normally adjusts relative cell references as you copy a formula. That is helpful when adding corresponding values on each row, but it can be unexpected if you meant to keep one reference fixed. Inspect the copied formula and compare its references with the source row; use absolute references when a cell must stay fixed while copying.
Does this work in Excel for Mac and Excel for the web?
Yes. The basic plus-sign and SUM formulas work in Excel for Microsoft 365 on Windows, Excel for Mac, and Excel for the web. You can enter them in a cell in each version; menu positions and some shortcuts differ, so use the relevant ribbon command if a Windows shortcut is not available.
Related
- Excel Extract Text From the End of a String in 365
- Excel Power Query: Extract Text from a String
- Extract Email Addresses From Text in Excel 365 Easily
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Structured References in Excel Formulas: A Practical GuideStructured references are Excel table references that use a table’s name and column headings instead of ordinary cell…
- Excel Sort Multiple Columns: Rules, Steps, and TipsTo sort Excel data by multiple columns, select a cell in the data, choose Data > Sort, then…
- Excel Power Automate Filter Query: Syntax and ExamplesIn Power Automate, filter Excel table rows by entering an OData-style condition in the Filter Query field of…
- Excel Date Subtraction: Formulas, Days, and WorkdaysTo subtract one date from another in Excel, subtract the earlier date cell from the later one: if…
- Excel Conditional Formatting: Use a Formula for RulesYes. In Excel, conditional formatting can use a formula that evaluates to TRUE or FALSE to decide which…
- SUMIFS in Excel: Count or Sum Matching Values?SUMIFS in Excel adds numeric values that meet one or more conditions; it does not normally count matching…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.