Counting cells with number

[Keala]

I have issue in count cells which I hope you can suggest a solution for.

I have column with a mix of 0s and value >0. So I need to count number of zeros in between each number>0 and state it on the next column.
It looks like this and what I want to achieve:
1
0
0
0
0
12 count= 4
0
0
0
3 count=3
0
0
0
0
0
0
55 count=6
...

The number of zeros is different all the time, sometimes it is only 3 zeros then a number or sometime it is 55 zeros then a number. I could do this manually with count function but since it is more then 300000 rows it will be quite demanding.

All suggestions are appreciated, maybe a macro is not neccessary and a work sheet solution would do it?

 

[AlanY]

have a look of this to see if you can spot the problem

https://drive.google.com/file/d/1J5698ntsv8GHREQI1T67W6_4yFx-EtOa/view?usp=sharing

 

[Keala]

Yes but with some modification. Following code work for me:
[/code]
=SUM(A1:A3)
=COUNTIF(A1:A3;">"&1)
the , is replaced with ;
but the same change in the original code will only give a green arrow at left upper corner on the cell.

 

[Keala]

Thank you for your help and suggestion, now for a unclear reason it works now! (Which is the main thing.)