Countif 2 variables

[tdm1103]

Hi,

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

 

[T. Valko]

This makes more sense, I am using Excel 2010.

Good deal. Thanks for the feedback!