Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    London, United Kingdom
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sum same cell reference thoughout workbook (2000 SR-1)

    I have inherited a petty cash workbook. In cell H9 on every single sheet is the monthly total of taxi fares. What is required at the top of the worksheet (in a cell of my choice) the running total for the whole year.

    Any advice on a formula would be greatly appreciated.

    Regards

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sum same cell reference thoughout workbook (20

    Hi Hetty

    You can use <code>=SUM('First sheet name:Last sheet name'!H9)</code>

  3. #3
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    London, United Kingdom
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sum same cell reference thoughout workbook (20

    Thank you very much. Does exactly what I want it to do.

    Regards

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sum same cell reference thoughout workbook (20

    Hi Hetty,
    Tony gave an acceptable solution, but just watch out that you do not move sheets around in that workbook, as that will "corrupt" the formula.
    It is longer to set up, but safer to create an expression such as:
    =NameOfSheet1!H9+NameOfSheet2!H9+NameOfSheet3!H9+N ameOfSheet4!H9.
    If you move sheets around in that workbook, the formula does not alter or mis-calculate!
    Regards,
    Rudi

  5. #5
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    London, United Kingdom
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sum same cell reference thoughout workbook (20

    Good point.

    The workbook is in month order, and hopefully no one will decide to rearrange the months of the year! But you never know there could be an executive decision!

    Thanks for the warning and I have two formulas to fall back on.

Posting Permissions

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