|
Criteria question
I have the following formula:
=MIN((I18),I16) How do I add a criteria "Medical" from column "D" -- Geo |
Criteria question
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 |
Criteria question
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 |
Criteria question
=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 |
Criteria question
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 |
Criteria question
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 |
Criteria question
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 |
| All times are GMT +1. The time now is 10:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com