Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Columbus, Ohio
    Posts
    234
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Sum of future data cells (XP SR3)

    Hi
    I have a spread sheet with several worksheets to record account balances. Each month I enter the new balance on each worksheet. What I want to do is have a summary worksheet that pulls the latest total over. For example, Column A has the month/year and column B has the ending balance, how can the summary sheet pull just the latest and final entry cell of each worksheet.
    I hope you can understand the question, I was trying to be brief, but can explain more if needed.

    Thanks,

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sum of future data cells (XP SR3)

    <P ID="edit" class=small>(Edited by mbarron on 24-Oct-08 11:39. fixed a typo)</P>Does something like the attached work for you?

    The formula involved:
    =INDEX(AccountA!A:A,MATCH(3E+100,AccountA!A:A,1))
    Attached Files Attached Files

  3. #3
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sum of future data cells (XP SR3)

    If you list the tabs in the A column as I had shown in my example sheet and the month and balance were in the B ad C columns you could also use:
    Entered in the B column and copied to the right and down (or down and to the right)

    =INDEX(INDIRECT($A2&"!A:B"),MATCH(3E+100,INDIRECT( $A2&"!A:a"),1),COLUMN()-1)

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Columbus, Ohio
    Posts
    234
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: Sum of future data cells (XP SR3)

    I think that did it.

    Thanks,

    Rick

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Columbus, Ohio
    Posts
    234
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: Sum of future data cells (XP SR3)

    ps: I laughed reading your Groucho Marx quote. I went to Brainy Quote online and printed out pages of his other witty quotes. I had some good laughs today. Thanks.

Posting Permissions

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