lowest number in a set EXCLUDING zero

[Bad Kitty]

I'm trying to figure out which formula to use to find the lowest value (all
numbers) in a range excluding zero. I've tried MIN, MINA and DMIN, which I
think is the correct one....but I'm not sure how to set the criteria to >0

Thanks for any help

 

[Duke Carey]

This is an array formula, entered by pressing Ctrl-Shift-Enter

=MIN(IF(A1:A3>0,A1:A3))

 

[JMB]

A non-array approach I saw Harlan Grove use:

=SMALL(A1:A7,COUNTIF(A1:A7,"<=0")+1)