How to add numbers in Excel – 5 easy methods

First, select a cell and type “=” in it.

Next, type the numbers (=23+11), and press Enter.

Select an empty cell. This will be the one where the results will appear.

Next, type “=” in the cells and this time, instead of typing numbers, type the cells. For example, type =D2+D3 and press Enter.

First, select a cell, an empty one, and type =SUM. Next, add a bracket after it and then type the cell numbers. It should look like this:

Once done, press Enter, and the numbers within the selected cells with get added.

First, select cells containing numbers. You can either select rows or columns, as the AutoSUM feature works with both of them.

Now, go to the Home tab, and click on AutoSUM.

Once done, the numbers will get added, and the result will either appear below the cells or on the right side (if you were adding a row of numbers).

First, select an empty cell and type =SUMIF.

Now, you need to type the cells you need to add, and then select a criteria. For instance, we want to add the numbers from D2 to D6. However, we only want to add numbers that are less than 9. So we will type =SUMIF(D2:D6,”<9″).

Once done, press Enter, and this will be the result.

As you can see, Excel added every number, but ignored 11 as it was greater than 9.