Count consecutive cells that contain yes, reset count after no

Occasional Visitor

Hi there! 


Does anyone know how to count the number of consecutive cells in a column that contain Yes, but reset the count if a cell contains No? 

I'm making a spreadsheet for a family health challenge, and we have to reach a consecutive 75 days, if we miss one, we start over. I'm hoping to find a way for the spreadsheet to track that. Thank you! 

1 Reply


I see you have Excel 365.


Try this: