[Solved] Counting cells

[3VA41570]

Hello,
I am recording the speed of a motor. For this I use a sampling device that give me in the first cell the speed number every turn. The rest of the time is recording cells with 0 , 0, 0,..etc until it finishes a complete turn and gave me the speed number again. For example 200.
So The spreadsheet is something like
200
0
0
0
0
201
0
0
0
Becuase the number of 0 between turns changes...is there any way to count how many 0 do I have in betwwen two marks of 200 or 201?
Thank you!

[RusselB]

First thing that comes to my mind, is using the COUNTIF function, though a few difficulties do come to mind quickly, namely: How to ensure that the range starts at the cell that contains the 200 and ends at the cell containing 201
I'm too tired to try to work out a solution at the moment, but that gives you (and others) something to possibly work with. I'll see what I can do when I'm more awake... presuming someone else hasn't beat me to the punch.

[Zizi64]

Here is a tip with a helper column:

Counting.ods

(10.35 KiB) Downloaded 111 times

[3VA41570]

Thank you so much!