Free Excel Training Online Lesson Five: Totaling Up Automatically

2KO Africa welcomes you back to our free Excel training online. Now that we have had a look at using formulas to get totals quickly, we can go on to Totaling Up Automatically.

Lesson 5

Totaling Up Automatically

We looked at adding a series of numbers together in lesson 4, and we will now go on to letting Excel auto sum / auto calculate for us. Yes, things just keep getting easier and easier, with us as users needing to do less and less.
 

Let's begin by totaling up a series of cells which are next to each other, which is the most common layout in Excel.
 

Autosum for a Series of Consecutive Cells

Look at Table 11, below.

Table 11

 

We are going to use Excel's Autosum Tool, to calculate the values for us in column A.
 

To begin, we will position the cursor in A8, which is the first blank cell below the data. Then we can use Autosum.
 

Excel's Autosum tool does what the name suggests - it sums (totals up) a series of numbers automatically.
 

Warning - beware of anything that is too automated. When we have very little input into the process, things can go wrong, because the computer is guessing / assuming which numbers need to be added.


We will position our cursor in A8, and then ...


1.   Hold down the ALT key on the keyboard and type an =
2.   The result will be as follows (see Table 12)



Table 12

 

Excel has detected a series of numbers directly above the cell selector, and has automatically selected the cells, and has inserted the SUM() formula, which we learned in Lesson 4.


Since these are indeed the numbers we intended adding together, all that ios left for us to do is press the Enter key. The result is placed into cell A8.


Another way of achieving the same result, is to delete whatever answer may be in cell A8, and then while in A8, to click the Autosum tool, in the Home Menu Tab.


Note - the Autosum tool also appears in the Formula Tab, and looks like this 
 

If you click the Auto sum button / icon once, the result will be the same as in Table 12 above.


To insert the answer, simply click Autosum button once more. The result is now inserted in the cell, A8.


Let's look at a different example:
To total a block of cells, and place the total sum in another cell, not necessarily adjacent to the original numbers.

Look at Table 13
 


Table 13

 

In this exercise, we want to total all values from cells A1 to C7, and we want to place the answer in D7.


Steps to Follow
1. Select cell D8, which is where we want the answer to appear.
2. Click the Autosum tool
3. Select the cells from A1 to C7
4. Press Enter
5. The answer should be 9388
6. The formula should be =SUM(A1:C7)

Check the Answer is Right
1. Highlight the cells with your mouse that you want added together. In this case that would be cells A1 to C7.
2. Whilst the cells are highlighted, look at the bottom right of your screen, and you will see Excel supplies a quick summary of the values highlighted.
3. The sum value in the summary should show 9388.

Let's now expand the exercise by tackling numbers which are not together.
 


Table 14

 

In Table 13, we wish to add together all the numbers in the table, and the answer must go in cell B10.


This is how we would tackle this calculation, using Autosum.


Steps to Follow
1. Select cell B10, which is where we want the answer to appear.
2. Click the Autosum tool
3. Select the cells from A1 to C2
4. Type a comma
5. Select the cells from A6 to C7
6. Press Enter
7. The answer should be 4463
8. The formula should be =SUM(A1:C2,A6:C7)

Another way of selecting cells which are NOT adjacent, is to use the CTRL key when selecting. So here are the steps again, using this modification:

Steps to Follow
1. Firstly, delete the value in B10, if there is already a value.
2. Select cell B10, which is where we want the answer to appear.
3. Click the Autosum tool
4. Select the cells from A1 to C2
5. Press and Hold down the CTRL Key on the keyboard
6. Select the cells from A6 to C7
7. Press Enter
8. The answer should be 4463
9. The formula should be =SUM(A1:C2,A6:C7)

Practise on your own

Open the document called Free_Excel_Training_Online_Lesson_5.xlsx


1. Complete an answer for Total Hardware in B9
2. Complete an answer for Total Software in B10
3. Complete an answer for Total HW+SW for Jan to Mar in cell C12


Check your answers:

If you would like to check your answers, click here        (Note the file will open in Excel)


To start lesson 6, click here

To go back to the index of free online excel lessons from 2KO Africa in Cape Town, click here