Finding minimum value in a column based on multiple text criteria in other columns

This formula allows me to find the lowest value in column U where column N contains the text "NO".

{=MIN(IF($N$2:$N$10000="NO",$U$2:$U$10000))}

I want to add another condition so that the formula only returns the lowest value in column U where (i) column N contains the text "NO" and also (ii) column F contains the text "YES".

Any suggestions gratefully received.

Thank you.

Try:

=MIN(INDEX(($N$2:$N$10000="NO")*($F$2:$F$10000="YES")*$U$2:$U$10000,0))

Edited to add:

Sorry, being stupid. Try:

{=MIN(If(($N$2:$N$10000="NO")*($F$2:$F$10000="YES"),$U$2:$U$10000))}

Thank you both.

Those should both work (I have entered them as arrays) but they are both returning 0. The answer should be much higher - there are no 0 entries in column U.

Any ideas?

Are there any rows which meet the criteria? Is the value in column F exactly equal to "YES" (and not say "Yes", "yes", "YES " or "Y")?

Not case-sensitive? Well, every day's a school day, isn't it?

It will, however, be sensitive to leading or trailing spaces, so do check for those.

I think this must be the problem.

When I add a column:

=IF(AND((F1="YES"),(N1="NO")),"GOOD","BAD")

I get some "BAD"s even where F1="YES" and N1="NO". But I can't work out why!

Try just =F1="YES" and copy down and see how many FALSE answers you get.

It's very strange. I get all correct answers when I do =IF(F2="YES","CORRECT") and = (IF(N2="NO","CORRECT")

But not when I combine them!

Can you post a sample of your workbook?