Count number of times an event occurs between recurring events

[Napoleoncarrot]

I am trying to count how many times an event (over pressure) occurs between a recurring event (start), I have >10000 entries. My column looks like,

start
over pressure
over pressure
start
over pressure
start
over pressure
over pressure
start
start
start
over pressure
start

In some instances no over pressure is detected
Ideally I'd like the output to read for this example to read
0
1
2
0
1
0
1
2
0
0
0
1
0

 

[Eric W]

Welcome to the board.

Maybe:

	A	B
1	Event	Count
2	start	0
3	over pressure	1
4	over pressure	2
5	start	0
6	over pressure	1
7	start	0
8	over pressure	1
9	over pressure	2
10	start	0
11	start	0
12	start	0
13	over pressure	1
14	start	0

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet8​

Worksheet Formulas Cell Formula B2 =IF(A2="start",0,SUM(B1,1)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[hotabae]

If I could piggy back off of Eric Above, I did it using a manually typed 0 in B2, with this formula in B3 and below (dragged down):

=IF(A3="over pressure", B2+1,0)

Edit: also... fun fact: turns out I was also working off of my Sheet8 xD

 

[Napoleoncarrot]

Thanks exactly what I needed.

 

[Eric W]

Glad we could help.