Try...

=ROWS(A2:A10)-MATCH(TRUE,A2:A100,0)

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
"Bruce" wrote:

Great, works a treat...

Didn't think i would have to resort to VBA but just the same solved my prob.
Gonna think this through now to work out a similar function for the reverse.

i.e. Cells since first non-zero value appeared.

Rgds,

Bruce