Modify this to suit your needs and ARRAY enter using ctrl+shift+enter

=MIN(IF(D2:E22="a",C2:C22))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dallman Ross" <dman@localhost. wrote in message
...
I'm tryinng to work on some new ideas today in Excel 2002.
Things look promising, but I just can't quite make these dang formulas
work.

The current problem is this: I want to know the minumum price from
a column (H) whose named range is "colPrice", but only when Column
C (named "colSymbol") matches my condition.

For example, there is the symbol ALTR in colSymbol. It appears
twice. There are two prices in colPrice for that symbol. They are
22.53 and 23.03. The formula should tell me the lowest one.

I tried this:

=MIN(SUMPRODUCT(colPrice*(colSymbol="altr")))

I get an answer of 45.56, which is nonsense! There is no value 45.56 in
the entire table! The table has 26 columns and 169 rows of data at
present.
Can someone please give me a shove and tell me what I've done wrong?
Would
be most appreciated.

Thanks!

--
dman