Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
running total where old data is replaced by new data
We are trying to create a spreadsheet to track hours worked on projects. We
will enter hours per person per day for one week to give a total for the week. I've got this set up, no problem. We will also have a running total--but we want to be able to replace the data entered in the week with the next week's hours, so that the running total will be cumulative of all the weeks entered without having to add more rows. We don't need to save old data, but we do need the totals to add up. I don't know if Excel can even do that. I have a back up plan, but am hoping to at least find out if Excel has this capability. Let me know if you need more clarification. Any assistance would be greatly appreciated. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
running total where old data is replaced by new data
See John McGimpsey's site.
Note the caveat about having no audit trail and difficulty in correcting errors when accumulating. http://www.mcgimpsey.com/excel/accumulator.html Gord Dibben MS Excel MVP On Wed, 21 May 2008 12:26:16 -0700, denovo wrote: We are trying to create a spreadsheet to track hours worked on projects. We will enter hours per person per day for one week to give a total for the week. I've got this set up, no problem. We will also have a running total--but we want to be able to replace the data entered in the week with the next week's hours, so that the running total will be cumulative of all the weeks entered without having to add more rows. We don't need to save old data, but we do need the totals to add up. I don't know if Excel can even do that. I have a back up plan, but am hoping to at least find out if Excel has this capability. Let me know if you need more clarification. Any assistance would be greatly appreciated. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
Can you use two running total data items to calc a third data item | Excel Discussion (Misc queries) | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |