Are the words Group, Use, Finish and List_Price defined names? (eg
from row 3 onwards?) If so you can try this array* function:

=MIN(IF((Group=$A$1)*(Use="X")*(Finish="Red"),List _Price,10E10))

An aray function must be committed with the key combination CTRL-SHIFT-
ENTER (CSE) instead of the usual ENTER.

Hope this helps.

Pete

On May 6, 5:13*pm, Jon Ratzel
wrote:
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