Forum Discussion
Count consecutive cells that contain yes, reset count after no
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 ch...
I see you have Excel 365.
Try this:
=LET(list,E1:E1000,blanks,COUNTBLANK(list),dynamic,DROP(list,-blanks),REDUCE("",dynamic,LAMBDA(a,v,IF(v="No",0,1+a))))