Two Criteria MIN function

Hi,

I kindly seek the wisdom of the excel gurus. I am stuck and I would sincerely appreciate some guidance.

Here is my issue:

I am analyzing quotations from multiple vendors, for multiple products.
Some of the quotes are valid, and others are deemed invalid (by me). I need a function to find the MIN value of the valid quotes for the given Product.

I am able to find the MIN value without taking into consideration the quote's validity, but doing so will give me false results. I could go through and manually remove all the invalid quotes, but I would prefer to do it with a formula.

I've tried using the AND function, but to no avail. (=MIN(IF(AND(Rangeof Products=SelectedProduct,RangeofValidquotes="yes"),Range of Quoted prices))

I've attached an example for more detail.

Thank you again!

J