MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Running Balance


Posted by Michelle on January 24, 2002 12:26 PM

I need a formula to keep a running balance. In one cell I have hrs calculated for the week, but I want to keep up with the total hrs. So, when the weekly hrs. change, it automatically adds to the total hrs, like this:

Total hrs for week - 40
Total hrs for month -40

and when I add next weeks hrs:

Total hrs for week - 40
Total hrs for month- 80

Total month hrs should increase everytime I put in the weekly hours.
Is this possible?


Posted by on January 24, 2002 3:10 PM

no

Total hrs for week - 40 Total hrs for month -40 Total hrs for month- 80

Posted by Bariloche on January 24, 2002 7:45 PM

By formula, no. By VBA, yes

Michelle,

The person who was so rude as to not post his name is correct. A fomula can't help you. If you would like a VBA solution, then it can be done. There is a solution that I posted on this board at this link.

If you'll give me specifics regarding your data set up I can modify that code to do what you need.


enjoy

Total hrs for week - 40 Total hrs for month -40 Total hrs for month- 80

Posted by Bariloche on January 24, 2002 8:02 PM

Correction: By formula, yes

Michelle,

Assuming your "Total hrs - week" are in cell B1, enter =B1+B2 into cell B2 and you should get the result you desire.


have fun

Posted by Bariloche on January 24, 2002 8:07 PM

Re: Correction: By formula, yes

I forgot to mention that you need to set "Maximum Iterations" to 1 in Tools > Options... > Calculation (check "Iterations").

If this solution is not acceptable, then we're back to using the VBA solution.

enjoy

Michelle, Assuming your "Total hrs - week" are in cell B1, enter =B1+B2 into cell B2 and you should get the result you desire. have fun