Minimum of Values that aren't zero

Hi,

I would like to create a formula to return the minimum of a range of values, but not to consider zero. For example, if the values were 0, 1, 2 and 3, the MIN formula would return 1.

What formula would achieve this?

Thanks!

Try:

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

This is an array formula, so after entering it, you need to confirm with CTRL + SHIFT + ENTER.

HTH,
Jason

Hello

Try following formula, Assuming numbers are in range A1:A100

=SMALL(A1:A100,COUNTIF($A$1:$A$100,0)+1)