Having trouble with sums and accumulations of numbers

[PSmith26]

I am working on a spreadsheet that has the following

Hrs by month /Accumulated Hrs per employee then at the end of each row there is a total for hrs for the month and a accumulated total.

In addition there is a row for Total Amount by month/ Accumulated Total Amount per employee and at the end of the row there is Total Amount by month which would consist of adding each employees month total and a Accumulated Total which would be all the accumulated totals for each employee.

I did not set this up and can not figure out how to enter the monthly total have it accumulate then the next month start with zero for the month and still have the accumulated total stay the same until I enter a monthly total for the employee.

Sometime months the employees work on that particular task and other months no work is done.

So I need a formula that will let me change the monthly total to zero if no work was done but keep the accumulated total the same amount from the previous month until work is done on that task again.

Sorry to ramble but this is the only way I can explain it.


I added a excel sheet that explains my problem better.

[oldchippy]

Hello there and welcome to the forum,

Can you could provide a zipped sample of your spreadsheet, I’m not understanding the question entirely, it may make things easier to understand if we could see what you are looking at?

To post a zipped example, go to “My Documents” or wherever you have your file stored, right-click and “Send to > Compressed file”, then attach this zipped file to your post.