Need Help Designing Forumla that gives result based on consecutive criterion

[Bill Bisco]

I have a a worksheet with a list of data points in Row 9 Column D. The data points continue on for a long time.

I want to know how many consecutive data points from the whole range equal to 1 or 0.

I believe I need to create an Array Formula to do this. Any help is appreciated.

 

[Bill Bisco]

I found the answer I was looking for. Modify the range to taste:
Array Formula

=MAX(FREQUENCY(IF(B2:O2<2,COLUMN(B2:O2)),IF(B2:O2>1,COLUMN(B2:O2))))