Hi Fotis1991,

Thanks for your reply.

The "Countif" function is part of the solution, but in addition to counting if value is greater than zero, I need the count to begin with the left-most cell, then count to the right each cell with a value greater than zero, until it hits a cell with 0, then stop counting.