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
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