Which means you are only looking at one cell - the upper most cell in the
range, in this case, A1. Use the Formula Auditor to step through your
formula and see how it's not actually performing without being entered with
Ctrl + Shift + Enter.

--
Regards,
Zack Barresse, aka firefytr

"Ron Coderre" wrote in message
...
That is . . .
=MIN(IF(A1:A6="x",B1:B6))works for me with and without CSE

--
Regards,
Ron