calculating the minimum value ignoring o
 

How do I calculate the minimum figure but ignoring and 0 values

For example:

8
0
5
8
0
2
4
0
3
7
8
the I looking for is 2

If no negative entries in the range of interest:

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

Otherwise:

=MIN(IF(Range,Range))

which must be confirmed with control+shift+enter, not just with enter.

jo jo wrote:
How do I calculate the minimum figure but ignoring and 0 values

For example:

8
0
5
8
0
2
4
0
3
7
8
the I looking for is 2