Try this array formula** :

=MIN(IF((Group="A")*(Use="Y")*(Finish="Red"),Price ))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Jon Ratzel" wrote in message
...
I need a formula that would work as a minimum ifs function similar to the
sumifs formula. Given the data set below I need the minimum list price for
the group in cell A1 but only only if the Use = Y and Finish = Red. Can
anyone help?

Group Use Finish List Price Min List Price
A X Red $10
B Y Blue $12
A Y Red $15 $15
C X Yellow $10
A Y Red $19 $15
B Y Red $9