What if you have 2 columns you need to check?

M2:M10="B" and N2:N105??


"Bernard Liengme" wrote:

=MIN(IF(M2:M10="b",F2:F10))
this is an array formula so commit it with SHIFT+CTRL+ENTER not just a
simple ENTER; Excel will enclose it in braces {}
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Rene" wrote in message
...
I'm looking for a formula that will find the MIN if 'b' is in the m column

=MINIF(M2:M10,"b",F2:F10)

excel 2007