Hi kvsrinivasamurthy

Thanks for helping me out with your formula - However I'm not quite sure if the formula works out what I need it to - The current total in E7 is 33 which is the Combined Total days worked, but I need it to count until the first blank day and then start again and not keep adding up, so I should have had 3 different answers in E7 (the first being 7, then 21, then the final answer being 5 as this is the total days worked since the last blank DV7:DW7). Then if I was to continue entering data the most recent answer of 5 would be overwritten with the new total.

Does this make sense?

Thanks again!