How to Add Two Cells in Excel

Techwalla may earn compensation through affiliate links in this story.

Learning to add two cells in Excel 2013 is a good way to begin to understand how formulas work. If the cells you are adding are located directly above the total's cell, AutoSum can add them automatically. To put the total in a cell located anywhere else, you can easily edit the AutoSum formula to get the result you need.

Advertisement

Adding Two Cells in a Column

Step 1

Click the cell directly beneath the cells you want to add. In the example here, we're adding cell C3 to C4 and having the sum appear in cell C5.

Select the cell beneath the last number.
Image Credit: Screenshot courtesy of Microsoft.

Step 2

Click the Formulas tab and then click the AutoSum icon. AutoSum automatically selects the cells above the one you clicked and adds them together.

Advertisement

Image Credit: Screenshot courtesy of Microsoft.

Step 3

The selected cells are highlighted and listed in the formula. Press Enter after examining the isted cells to ensure they are correct. In this example, the formula =SUM(C3:C4) indicates that the formula is adding cells C3 and C4. The colon between the cells indicates that Autosum is prepared to add a range of cells -- although in this case, there are only two.

Advertisement

Image Credit: Screenshot courtesy of Microsoft.

Step 4

Edit the AutoSum formula at any time by double-clicking the cell. Note that when you select the cell with a single click, you can see the formula in the Formula Bar above the worksheet.

The Formula bar displays the formula while the cell displays the result of the formula.
Image Credit: Screenshot courtesy of Microsoft.

Adding Cells That Aren't Directly Above the Total

Step 1

Click the cell where you want the total to be displayed. Click the Formulas tab and then click the AutoSum icon. AutoSum attempts to add any adjacent cells, but you can direct it to the right cells.

Advertisement

Image Credit: Screenshot courtesy of Microsoft.

Step 2

Highlight everything between the parentheses. Press Delete.

Delete the cells between the parentheses.
Image Credit: Screenshot courtesy of Microsoft.

Step 3

Press the Ctrl key and click the cells that you want added. If you click the wrong cell, click it again while the Ctrl key is still pressed down to deselect it.

Advertisement

Selecting cells C3 and C4 to add them together.
Image Credit: Screenshot courtesy of Microsoft.

Step 4

Press Enter to save the formula. The AutoSum formula adds the numbers. The total is displayed in the cell, while the formula is displayed in the Formula bar.

Image Credit: Screenshot courtesy of Microsoft.

If you'd like to learn more about AutoSum, learn how to add multiple cells as totals and subtotals.

Tip

To add cells, you can also just type the SUM formula, such as =SUM(C3,C4) or =(SUM(C3:C4). Alternatively, you can type the cells in parentheses, with each cell separated by the equal sign, such as =(C3+C4+C5+C6).

Advertisement