Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Nov 2003
    Location
    New York, New York, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Grand totals (2002 SP2)

    Is there a function to add a "grand total" after each month's subtotal other than doing so manually? Specifically, is it possible to show the sum of January & February following February ; the sum of the first three months following March; and so on. It is possible to do manually by adding a row and creating a new subtotal function. A sample sheet is attached.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Grand totals (2002 SP2)

    I don't know of a standard formula or wizard for this. I have attached a version of your workbook with formulas in column H that display cumulative subtotals. You only need to enter the formula in H3, then you can fill down by double clicking the fill handle in the lower right corner of H3.

  3. #3
    New Lounger
    Join Date
    Nov 2003
    Location
    New York, New York, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grand totals (2002 SP2)

    Thank you.

  4. #4
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grand totals (2002 SP2)

    I can't download the answer file provided, so it might have this, but I use the SUBTOTAL(9, etc) function alot. It is the function inserted in the Data/Subtotals process. Subtotal 9 is an addition subtotal. When you use that instead of the SUM function, you can have as many subtotals in a column or row as you want. excle ignores them when it takes a total. So the grand total subtotal(9, etc would not pick up any interim total. I find that very helpful, but I have to remember to always specify the total range to be added, since Excel ignores anything SUBTOTAL(9, formula in that range. I also combine it with the OFFSET function in the SUBTOTAL range so that I don't have to leave a line at the end of my range. HTH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •