I am just using formulas in excel and was wondering how you could count all the 0s until a 1 is reached, and then start the process over again. Would this be possible with just formulas?

Right now I am trying to use,

```
=COUNTIF(INDIRECT(F2:F28,0)),1)

```

... but it does not seem to work.

Data: 

```html
0
1
0
1
1
0
0
0
0
0
0
1
0
1
0
```