The ealier formula works only if the 1st cell starts with zero...If the 1st
cell do not have a zero then try the below

=MATCH(0.1,A6:J6)-MATCH(0,A6:J6,0)+1

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Try
=MATCH(0.0001,1:1)
OR
=MATCH(0.0001,A1:J1)

If this post helps click Yes
---------------
Jacob Skaria


"Bubba" wrote:

Is there a function, or combination of nested functions to count the number
of zeros in a row up until the first non-zero valued cell?

For Example

0 0 0 0 0 35 0 50 60
0 0 0 0 0 0 40 10 0 0 30

For the First Row I want the function to return the value 6 and the second
row to return the value '7'

I do not want to know the total number of zeros in a row, I want to know the
number of zeros in a row until I encounter the first nonzero cell.