You can use this array-entered** formula to do what you want (it will work
even if there are negative values)...

=MIN(IF(A2:A20<=0,"",A2:A20))

** Commit this formula using Ctrl+Shift+Enter and not just Enter by itself.

Adjust the ranges to match your conditions.

Rick


"Nigel Toates" wrote in message
...
I have a row of 19 cells that have many zeros in it but I need to find the
lowest value that is greater than "0"

The problem comes from having 19 months of sales figures and I want to
find
the lowest month value we had sales in.

Thanks Nigel