Remove data without disrupting previous calculations

So this is a workbook made for understanding how to figure it out, the real WB contains a whole year worth of weeks.

The problem is in WORK, there's a row called "budget hours", which checks how many hours the place "has" in DATA.

-But when person 2 quits, like this on the 20/4 - how do I stop him from being calculated from there on? I still need the "budget hours" to be correct from the time before 20/4.

ie. before the 20/4 they had 22,20 hours, but now that he's not there they only have 14,80 - but if I delete his hours from DATA, all previous calculations are messed up.

Any solution, almost no matter what would be appreciated!

http://www.excelforum.com/attachment...1&d=1460467671

Try the formula below to see if it does what you're looking for:

=SUMPRODUCT(--(O$3:O$22>0),(Data!D$7:D$26))

Paste it in O26 then fill right to S26. Repeat the process for your other weeks, but you'll need to make sure the columns are correctly aligned. The formula should only calculate the budgeted hours for workers whose output for the day in 'WORK' is not blank. It should allow you to leave a terminated employee blank in 'WORK' and have only the post-termination budgeted hours adjust accordingly.

I don't understand it - but it works! ty