Working with just your smaller data set I used
=MIN(IF(A2:A5="d",IF(B2:C50,B2:C5)))
and got 100 as expected
Of course it must be array entered with CTRL+SHIFT+ENTER
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Rene" wrote in message
...
MIN(IF(A2:A43="d",B2:BG43)) entered as an array

Does it return a 0 because of the blank cell? And how do I ignore the
blank
cell?

a2 b2 c2
d blank 120
d 100
d 150 175
a 75 90

Thanks