minimum value without zero

[steve]

If I have 4 cells, and I want the minimum value greater
than zero of the 4 cells, how do I write this?

Example
A2=3
B2=8
C2=0
D2=9

I want the formula (in cell E2) to return the value 3. If
I use MIN it returns 0. However, the list may have
multiple zero's.

Is there a way to put a constraint so it will return the
lowest value greater than zero?

 

[steve]

Thanks Chip!
Thanks Don!

This worked like a charm.

 

[steve]

Thanks Jason

-----Original Message-----
A non-array way (assuming no neg. numbers in range):

=SMALL(A22,COUNTIF(A22,0)+1)

With negative numbers:

=SMALL(A22,COUNTIF(A22,"<=0")+1)

HTH
Jason
Atlanta, GA


.