Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Nov 2003
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Running total for categories in a work book (2003 SP2)

    Hi All

    Hoping someone can help me with a formula for the attached workbook.

    It is a financial workbook to keep track of receivables and expenses. Each receivable and expense is entered and linked to a category in the "Cat" column. In worksheet "All FY2007" I want to keep a running total of each category. For example in the amount column in "All FY2007" the total for category 04 would be $300.00 which is the total for category 04 from worksheets "July 06" and "Aug 06".

    I would very much appreciate if someone could help with a formula to keep the total for each category for the whole twelve months.

    Thanks

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

    Re: Running total for categories in a work book (2003 SP2)

    See 3D User Defined Functions for a set of functions that will work with 3D ranges (i.e. spanning multiple sheets).
    I used the second set in the attached version; you can adapt the use of the formulas to your needs. Since the workbook contains VBA code, make sure that macro security is not set to High.

  3. #3
    New Lounger
    Join Date
    Nov 2003
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Running total for categories in a work book (2003 SP2)

    Hi Hans

    This does exactly what I wanted. Your help is much appreciated.

    Regards
    Paul

  4. #4
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Running total for categories in a work book (2

    Hans, you're a star!

Posting Permissions

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