Find the smallest amount
 

Is there a formula I can use to tell me the smallest amount for a list of
values?
For example:

Column A B C
Dog Black $100
Cat Black $50
Dog Black $50
Dog White $25

I want a formula that will tell me the smallest value for Dog & Black is $50

Find the smallest amount
 

This is an array formula that must be entered using ctrl+shift+enter and pls
notice the ranges are the same size.
=MIN(IF((O14:O24="dog")*(P14:P24="black"),Q14:Q24) )

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Brian" wrote in message
...
Is there a formula I can use to tell me the smallest amount for a list of
values?
For example:

Column A B C
Dog Black $100
Cat Black $50
Dog Black $50
Dog White $25

I want a formula that will tell me the smallest value for Dog & Black is
$50