MIN with a condition

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!

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 {}

--
Andy.


"Sarah" wrote in message
...
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!