=MIN(IF(D11:D5000="Medical",E11:E5000))

entered with ctrl + shift & enter

if you want to test it against I16 then use

=MIN(MIN(IF(D11:D5000="Medical",E11:E5000)),I16)


also array entered


--


Regards,


Peo Sjoblom



"Geo" wrote in message
...
Thanks
Medical is one of the criterias and is inserted in rows D11 to D5000, in
rows E11 to E5000 is a figure, which the sum total is found in cell I18.
The formula is in cell I20 which sums total for Medical under a figure in
cell I16 (variable fugure).
--
Geo


"Peo Sjoblom" wrote:

What does that mean, which cell holds Medical? Also no need for an extra
parenthesis in your formula

=MIN(I18,I16)



--


Regards,


Peo Sjoblom


"Geo" wrote in message
...
I have the following formula:

=MIN((I18),I16)

How do I add a criteria "Medical" from column "D"
--
Geo