MIN with a condition

[Sarah]

I am having no luck writing a formula that will return
the MIN value from column B when column A = "Admin".

Example data:

A B
Admin 5
Mktg 10
Supplies 4
Admin 12
Admin 6
Mktg 5

I want the formulat to return the value of 5 for a MIN if
A=Admin.

Help is appreciated!

 

[Andy B]

Hi

=MIN(IF(A2:A7="Admin",B2:B7))

You need to array-enter this by confirming the formula with Ctrl Shift and
Enter, instead of just Enter. If you do it right, Excel will enclose the
formula in curly brackets {}