Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Feb 2005
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Need a formula? (Excel 2003)

    Lets say I have two bank books. I put my starting balance on Sheet1 in cell D3 $5,000.00 - for my first bank book. I put my starting balnce on Sheet2 in cell D3 $10,000.00 - for my second bank book. I want a running total of the two bank books on Sheet2 in cell E4. So I need a formula in cell E4 on Sheet2 that gives me $15,000.00.

    Now here is my problem. I will be taking money out of both bank books. So lets say I take out 200 on Sheet1. I would put that number in cell C4 and my new balance would show up in D4 as $4,800.00. I now need in Sheet2 cell E3 to show $14,800.00.

    Now lets say I take out more money from bank book one or Sheet1. I take out 300 and then 400. So I will put 300 in C5 and 400 in C6 and my new blance in D6 in now $4,100.00 in Sheet1.

    I also take money from bank book two or Sheet2. I take out 1000. So I will put $1000.00 in cell C4 and my new balance would show up in D4 as $9,000.00. Now I need my formula in cell in cell E3 on Sheet2 that gives me $13,100.00.

    So I need a formula in Sheet2, cell E3, which will continue to give me the results I

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Need a formula? (Excel 2003)

    Does your column D contain the formulas for the running total on each sheet already, or do you copy them down as you withdraw/pay in money? Also, is there anything in D13 on each sheet?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    2 Star Lounger
    Join Date
    Feb 2005
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need a formula? (Excel 2003)

    See attachment
    Attached Files Attached Files

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Need a formula? (Excel 2003)

    This formula in E3 should work if that is the layout:
    <code>=OFFSET(Sheet1!$D$3,COUNTA(Sheet1!$D:$D)-1,0)+OFFSET($D$3,COUNTA($D:$D)-1,0)</code>
    HTH
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    2 Star Lounger
    Join Date
    Feb 2005
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need a formula? (Excel 2003)

    I'm sending you my original template. Here is what I want. In Supplies Master sheet, in cell C2, I want the Allocation value in Staff Support sheet (at this time H15 (1673.04) to show up in Supplies Master sheet, in cell C2. As I continue to add information in Staff Support sheet , I need only the last value to show up in Supplies See new attachment. Master sheet, in cell C2. Need the good formula to show up in Supplies Master sheet, in cell C2.

    I want to do the same with Office Supplies sheet. Put the last running total in Supplies Master sheet, in cell C3.

    I gave you bad information before. Hope you can help me with this. Sorry for giving you the wrong information before.
    Attached Files Attached Files

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Need a formula? (Excel 2003)

    See attached version - same basic theory as before.
    Attached Files Attached Files
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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