=MIN(IF($E$4:$E$1040,$E$4:$E$104))

ctrl shift enter (not just enter)


"CharlieS" wrote:

Hello all! I have a formual set up to return the smallest number in a
column...
=SMALL($E$4:$E$104,1)
However, I need to to return the smallest number greater than zero. We have
a contest going on and based on sales vs. the employee guess we may have some
negative numbers come up so I don't want them to show in my top 5... Can you
help?