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
C5". So we'll have
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
E3", which gives us
Similarly, for Oliver's balloons, we write the cells
C4:E4 and for Alex's balloons
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.
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
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
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
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.
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.