Finding the MIN value, but greater than zero

G

Glenn L.

I need to find the minimum value in a data range (F174:F188), but greater
than zero. I tried "=MIN(F174:F188>0)" and it does not work. How can I do
this?
 
M

Mike H

Try

=MIN(IF(F174:F188 >0,F174:F188))

Enter with Ctrl+Shift+Enter NOT just enter

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't seem to delete all images from a Word Doc 2
MIN function 5
Use TODAY() function as the criteria in a SUMIF formula 1
Highlight MAX Cell Greater Than Zero 4
min thats = 0 6
HLOOKUP, LOOKUP & MATCH doesn't work. Seems not right. 1
If formula: if A1 is greater than B1 and A1 is greater than zero.. 2
Last Value Greater Than Zero 7

Top