Counting 6 consecutive 0's

[bhenderson]

Hello all,

I am not sure if this is more a function or a programming question, but I have a sample attached where I am trying to count 6 consecutive 0's in each row to help me identify trends. I am hoping for my end result to give me something akin to a pivot table that would have...

ID # Times 6 consecutive 0's counted
1 0
2 2
3 4
4 0


Any ideas for how to get from the sample to the intended result?

I tried using frequency functions but I am not quite getting it yet.

Thank you,
Ben