IF statement for consecutive cells

[cloughie]

Hi I'm trying to write an IF statement that will tell me if 3 consecutive zero's appear in the row of another worksheet. I also need the statement to tell me if there are more than 3 as well.

 

[Special-K99]

This seems to work, play around with some test data to be sure.
Put the data in A1:H1

=COUNTIFS(A1:H1,0,B1:I1,0,C1:J1,0)

If the result equals 1 then there are 3 consecutive zeroes.
If the result equals 2 or more then there are more than 3 consecutive zeroes.

 

[cloughie]

Thanks for this, I should have been a little clearer though.

I have 3 sheets, the first has raw data. The second is using a countifs with wildcards formula to pull the information I need. The third sheet needs to pull the information from the 2nd sheet but needs to identify consecutive zero's up to a specified date range. With any consecutive zero's after this point returning either a text value or a blank cell.