Using MIN on range with upper and lower bounds

Hi all,
I have two named ranges, "Frequency" and "Power". I'm trying to find the minimum power level within a certain bandwidth (between two frequencies). Here is my formula:

Please Login or Register  to view this content.

With this formula I get #Value!, and the error says "A value used in the formula is of the wrong data type."

However, when I take out the AND statement and only have the lower bound, as in the formula below, it works fine.

Please Login or Register  to view this content.

Any ideas as to what is going on here? I've attached my workbook to play around with.

Thanks!

Try:

=MIN(IF((Frequency>1215)*(Frequency<1400),Power,""))

AND() function doesn't work with Array Formulas.. instead we multiply the arrays to give same effect (or you can do nested IF functions...