I have a row of 24 values. I am looking to do a COUNTIF function that counts all cells that have a value that are greater than 1 and are preceded by "0". For example:

0 0

**4**5 2 0 0 0

**6**0 0 0

**7**8 9 6 0 0 0 0

**3**4 5 0

In the string of the numbers above, the COUNTIF function would return a value of 4.

Thanks