C+S+E = Ctrl+shift+enter. Yes there are zeros in the b range your formula
work i did not jnow the )*(

Thanks a bunch!!!!

"Peo Sjoblom" wrote:

Did you enter the formula with ctrl + shift & enter? Do you have any blank
cells in the B range? What do you mean with "Then C+S+E" If you mean that you
would have one formula with non-contiginous ranges with criteria it won't
work. If you have blanks you can change to

=MIN(IF((A1:A6="x")*(B1:B6<""),B1:B6))



Regards,

Peo Sjoblom

"sonofroy" wrote:

hi! I need some help again! I have a sheet setup like this.
a b
1 x 41
2 y 30
3 x 45
4 y 43
5 x 37
6 y 29

I am using the function
=MIN(IF(a1:a6="x",b1:b6)) then C+S+E

this keeps returning zero
How can I correct this formula to actually return the minimum for x instead
of zero

Thanks in advance.
Derek