How to add cells in Excel

The most essential features in Excel are often the simplest ones. You’ll find that almost every project requires some degree of math. In this case, we’re talking about the essential skill of adding cells. However, there are quite a few different ways to accomplish your goal. Here are two quick ways to add cells in Excel.

Read more: Ten best Excel and spreadsheet apps for Android

QUICK ANSWER

To add cells in Excel, use the SUM() function, entering the cells you want to add inside the brackets. Press Enter to see your results.

How to add cells in Excel

The most basic way to add cells in Excel is to write a formula.

Start with an equals sign (=) followed by your cells separated by a plus sign (+). In our example, this reads as =A2+A3+A4.

add cells in excel 1 1200x308 1

Adam Birney / Android Authority

Press Enter to get your result.

add cells in excel 2 1200x312 1

Adam Birney / Android Authority

This method is easiest if you add just a few cells and don’t mind typing them. However, you’ll probably find that using the SUM function to add long strings of cells is faster.

Start with the equals sign again, as this is how all formulas start. Then type SUM( to create your function.

add cells in excel 3 1200x331 1

Adam Birney / Android Authority

Now you can type in the cells you want to add and divide them with commas. This would read as such: =SUM(A2,A3,A4).

add cells in excel 4 1200x333 1

Adam Birney / Android Authority

If you’re adding a string of unbroken cells, you can separate them in your equation with a colon. This is easier if you have a long list because you can enter just the first and last cells. Our example looks like this: =SUM(A2:A4).

add cells in excel 5 1200x308 1

Adam Birney / Android Authority

A third way you can populate your formula is by clicking and dragging. After you’ve written =SUM, you can select the first cell you want to add and drag it to the last cell. Excel will do the rest and separate it with a colon.

add cells in excel 6 1200x333 1

Adam Birney / Android Authority

You can even add up all of the cells in a column at once. In your formula, note the cells as A:A. Your formula bar will display as =SUM(A:A).

Press Enter after you’ve decided on your cells to see the result.

add cells in excel 2 1200x312 2

Adam Birney / Android Authority

To add or subtract multiple cells, enter the plus (+) or minus (-) signs in between the cell numbers you want to combine into the function bar, and press Enter to display the results.

Use the formula =SUM(), with the cell numbers you want to add inside the brackets.

Leave a Reply

Your email address will not be published. Required fields are marked *