I have the following formula:

=MIN((I18),I16)

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

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

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

=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

Thanks Peo for thank,
But it's not working, it gives me the smallest figure entered, I need the
sum of entries for "medical" under the reference figure in I16.
--
Geo


"Peo Sjoblom" wrote:

=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

Are you saying that you want to SUM E11:E5000 where D11:D500 = Medical but
you only want to add those values less than or equal to I16? Given what you
posted in your first post I would say that was impossible to guess.

=SUMPRODUCT(--(D11:D5000="Medical"),--(E11:E5000<=I16),E11:E5000)

for values less than I16


=SUMPRODUCT(--(D11:D5000="Medical"),--(E11:E5000<I16),E11:E5000)

greater than or equal to I16


=SUMPRODUCT(--(D11:D5000="Medical"),--(E11:E5000=I16),E11:E5000)


greater than

=SUMPRODUCT(--(D11:D5000="Medical"),--(E11:E5000I16),E11:E5000)


--


Regards,


Peo Sjoblom



"Geo" wrote in message
...
Thanks Peo for thank,
But it's not working, it gives me the smallest figure entered, I need the
sum of entries for "medical" under the reference figure in I16.
--
Geo


"Peo Sjoblom" wrote:

=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

Thank you very much.
That works great, sorry about the vague notes.
--
Geo


"Peo Sjoblom" wrote:

Are you saying that you want to SUM E11:E5000 where D11:D500 = Medical but
you only want to add those values less than or equal to I16? Given what you
posted in your first post I would say that was impossible to guess.

=SUMPRODUCT(--(D11:D5000="Medical"),--(E11:E5000<=I16),E11:E5000)

for values less than I16


=SUMPRODUCT(--(D11:D5000="Medical"),--(E11:E5000<I16),E11:E5000)

greater than or equal to I16


=SUMPRODUCT(--(D11:D5000="Medical"),--(E11:E5000=I16),E11:E5000)


greater than

=SUMPRODUCT(--(D11:D5000="Medical"),--(E11:E5000I16),E11:E5000)


--


Regards,


Peo Sjoblom



"Geo" wrote in message
...
Thanks Peo for thank,
But it's not working, it gives me the smallest figure entered, I need the
sum of entries for "medical" under the reference figure in I16.
--
Geo


"Peo Sjoblom" wrote:

=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