Hi guys. I am just starting my way into depths of excel, and have encountered this problem.
I need to count how many ranges of consecutive cells containing zero is there in a row, counting only the ranges that are at least 2 cells large.
(EXAMPLE: 45757047400000000000456457457457000000000000000456450440 would return 2)
I am bad with this, but from the forums I have managed to combine this array function:
=COUNT(IF(FREQUENCY(IF(B1:B23=1,ROW(B1:B23)),IF(B1:B23<>1,ROW(B1:B23)))>1,1))
It works if my data is written vertically, but I need to work with data written horizontally. I know this might sound stupid to you, but please bear with a noob

What i have tried:
=COUNT(IF(FREQUENCY(IF(B3:O3=0,COLUMN(B3:O3)),IF(B3:O3<>0,COLUMN(B3:O3)))>1,1))
but this does not seem to return the right values.

Any suggestions?