Min value > 0

[sukhi_01]

here goes...

im trying to find the minimum value in a range that is greater than 0 as i have negative numbers in my range.

i also want to count the number of values that are in a range that are below a value of £20 but above the value of > 0.

can any one help?

thanks.

[BigBas]

An array formula will give the Min value greater than 0:

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

Note: Array formulas must be confirmed with CTRL+SHIFT+ENTER. If done correctly, {} brackets will surround the formula.

[darkyam]

Or =Small(A1:A10,COUNTIF(A1:A10,0)+1) This won't have to be confirmed with Ctrl+Shift+Enter.
Edit: Nevermind this, didn't see the part about negative numbers.