I am summing a column but if 8 consecutive cells are zero I would like it to return a zero total and then start adding again. The purpose being Statutory Sick Pay paid period zero's after 8 weeks of not claiming. So I can see in T100 the employee has had 17 weeks SSP he then isn't sick for 12 weeks so his SSP paid to date should return to zero but because the sum I have is =SUM(S$6:S59) it is just totalling the column. I hope someone can help. Thank you.