How do you use AutoSum to enter a formula in the selected cell to calculate the total of all the contiguous cells above?

The SUM() formula in Excel is used to add together the content of two or more cells. It takes the cell names and gives back the result of the sum.

Let's apply the SUM formula so we can see it in action. Say that you're organizing a party, and different people are bringing balloons in different colors. You'll record in a table how many balloons of each color each person brings.

How to add the cells in a column

First, we want to know how many balloons of each color people have brought to the party.

So based on the table above, to find out how many blue balloons we have, we can write the SUM formula in cell C6. Then we'll write the cells we want to add together as C3:C5, which will be interpreted as "all the cells from C3 to C5". So we'll have =SUM(C3:C5).

We can do the same thing for the green and white balloons, too - we'll write cells D3:D5 for green and E3:E5 for white.

How to add the cells in a row

Next, we want to know how many balloons each person has brought. To find out how many balloons Marisa brought, we can write the SUM formula in the F3 cell, and write the cells we want to add together as C3:E3. This will be interpreted as "all the cells from C3 to E3", which gives us =SUM(C3:E3).

Similarly, for Oliver's balloons, we write the cells C4:E4 and for Alex's balloons C5:E5.

How to add the cells in a block

The last thing we want to learn how to do is to figure out how many balloons we have in total.

To do that we need to sum all the balloons we have. We write the block of cells as C3:E5, which will select all the cells in the rectangle with C3 in the upper left corner and E5 in the bottom right corner.

How to add the cells in different intervals

If we want to know the sum of different intervals of data that are not near each other (for example how many blue and white balloons we have in total), we can use the SUM formula separating data intervals with commas.

So since C3:C5 is the interval for the blue balloons, and E3:E5 is the interval for white balloons, we can write =SUM(C3:C5,E3:E5). Also, as we already know how many blue balloons we have in total and how many white balloons we have in total, we can sum the two totals with =SUM(C6,E6).

How to add cells by selecting the data with the mouse

Up to this point we have typed out the names of the cells to select them. But Excel also lets you select the cells to use in the formula with the mouse.

Once you have written =SUM( then you can select the cells – if you want to select multiple intervals, you can just keep Ctrl pressed. Once you have finished, you can press Enter and the sum of the selected cells will be calculated.

How to add cells using AutoSum

There is a tool in Excel that lets you make simple sums with a click, called AutoSum. You can find it in the Home menu, and it has the symbol of a greek uppercase letter sigma (Σ).

With this tool you can, from the situation in the first image before any calculation was done, select the three cells F3, F4 and F5, press the AutoSum button, and it will immediately fill the cells with the sums of the cells to the left (the same result as we got when we added the cells in a row).

You can also select the three cells C6, D6 and E6 and press AutoSum to get the sums of the cells above (the same result as when we added cells together in a column).

Alternatively, the AutoSum tool can be used as a shortcut to writing the SUM formula: when you select only one cell and press the AutoSum button, the cell is filled with the SUM formula. Then you can select the cells to sum with the mouse or write the interval of the cells to sum inside the parenthesis of the formula.

If the selected cell is near other filled cells the SUM formula can be pre-filled with a suggestion of cells to sum.

Wrapping up

The SUM() formula lets you add together cells. In order to determine which cells to sum, you can type their names as argument of the SUM() formula, or you can select them with your mouse after you've typed the name of the formula and the opening parenthesis. The formula can also be used with the AutoSum tool.