I tried using the "Countifs" (Google Measure) …but, I’m hoping there’s a simple(r) way to "Look" 👀 …at:
- rows of zeros (0’s) …and
- determine how many times three (3) zeros appear [together]
- see Google Sheet – below ⤵️
Explained:
- Employee A …has 4 instances (over 18 weeks)
- Employee B …has 2 instances (over 18 weeks)
- Employee C …has 6 instances (over 18 weeks)
- Employee D …has 4 instances (over 18 weeks)
>Solution :
Here’s one approach you may test out:
=byrow(B2:S,lambda(Σ,if(counta(Σ)=0,,len(regexreplace(regexreplace(join(,Σ),"0{3}","Λ"),"[^Λ]",)))))
- the formula assumes there will be no blank cells in a given row of 18 weeks

