How to Add Subtotals to a Column in Excel

If you've ever wondered how to add subtotals to a column of numbers in your Excel spreadsheet without interfering with your actual total, this article will tell you how!

Difficulty: Easy

Instructions

Things You'll Need:

• A working knowledge of Excel functions and cells.

1. When you insert a subtotal for any numbers in a column, you're going to use the SUBTOTAL command for ALL the cells including the total of all the numbers. You DO NOT use the SUM command. Let's explain, and note the pictures:

2. 
    
   Note the formula bar.

   Place your cursor in the cell where you want to first subtotal. In this illustration, it's cell A5. Type:
   =subtotal(9,
   And then type the cells you want added for your subtotal. For this column, it's cells A1 through A4, so our command would be:
   =subtotal(9,A2:A4)

3. The number 9 after your subtotal command is telling Excel that the number in that cell is not to be added to your total at the bottom. Make sure you add this 9!

4. 
    
   Note the formula bar.

   Repeat this for any cell where you want to include a subtotal. Notice we've done this again in cell A9.

5. 
    
   Note the formula bar.

   For the cell where you want to have the actual total for all the numbers in the column, type:
   =subtotal(109,
   And then include all the cells you want totaled, and you can include the cells with your subtotaled numbers. Notice in our illustration the formula bar. For our total of the column, the formula is:
   =subtotal(109,A1:A10)

6. The 109 you type in this cell tells Excel that you're now adding all the numbers in the column but will skip the cells with the subtotal(9,) command. Make sure you add this 109 to your formula and don't use the SUM command.

[Glencap]

on 4/2/2009 I had forgotten how to do this. Now, I can stop wrecking my brain. Thanks a million!