Hello,

Maybe you have leading/trailing spaces? ...

=MIN(IF(TRIM(a1:a5)="x",b1:b6))

--
Regards,
Zack Barresse, aka firefytr

It
"sonofroy" wrote in message
...
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