Sum If on muliple conditions
I couldn't find the answer in this newsgroup...Is it possible to get the
Sumif statement to calcluate against three different criteria w/out creating multiple sumif statements? Ex: =SUMIF(G3:G10, "Jul", "Aug", Sep", H3:H10)? I know using the comma's in between the Months, but is there some other way to get this working? I can't use or < because the Month's are text only. |
Try
SUMPRODUCT((SUMIF(G3:G10,{"Jul","Aug","Sep"},B355: B364))) -sk FrankTimJr wrote: I couldn't find the answer in this newsgroup...Is it possible to get the Sumif statement to calcluate against three different criteria w/out creating multiple sumif statements? Ex: =SUMIF(G3:G10, "Jul", "Aug", Sep", H3:H10)? I know using the comma's in between the Months, but is there some other way to get this working? I can't use or < because the Month's are text only. |
Try
SUMPRODUCT((SUMIF(G3:G10,{"Jul","Aug","Sep"},H3:H1 0))) -sk |
Hi!
Try this: =SUMPRODUCT((G3:G10={"Jul","Aug","Sep"})*H3:H10) Biff "FrankTimJr" wrote in message ... I couldn't find the answer in this newsgroup...Is it possible to get the Sumif statement to calcluate against three different criteria w/out creating multiple sumif statements? Ex: =SUMIF(G3:G10, "Jul", "Aug", Sep", H3:H10)? I know using the comma's in between the Months, but is there some other way to get this working? I can't use or < because the Month's are text only. |
Sweet! Thanks a million!
"sk" wrote: Try SUMPRODUCT((SUMIF(G3:G10,{"Jul","Aug","Sep"},B355: B364))) -sk FrankTimJr wrote: I couldn't find the answer in this newsgroup...Is it possible to get the Sumif statement to calcluate against three different criteria w/out creating multiple sumif statements? Ex: =SUMIF(G3:G10, "Jul", "Aug", Sep", H3:H10)? I know using the comma's in between the Months, but is there some other way to get this working? I can't use or < because the Month's are text only. |
Better options:
[A] =SUM(SUMIF(G3:G10,{"Jul","Aug","Sep"}),H3:H10)) [b] =SUMPRODUCT(--ISNUMBER(MATCH(G3:G10,{"Jul","Aug","Sep"},0)),H3:H 10) [C] =SUMPRODUCT(SUMIF(G3:G10,{"Jul","Aug","Sep"},H3:H1 0)) Invoke [b] or [C] when you have {"Jul","Aug","Sep"} in some range, say X1:X3 which is then substituted for the {"Jul","Aug","Sep"} bit in these formula schemes. Biff wrote: Hi! Try this: =SUMPRODUCT((G3:G10={"Jul","Aug","Sep"})*H3:H10) Biff "FrankTimJr" wrote in message ... I couldn't find the answer in this newsgroup...Is it possible to get the Sumif statement to calcluate against three different criteria w/out creating multiple sumif statements? Ex: =SUMIF(G3:G10, "Jul", "Aug", Sep", H3:H10)? I know using the comma's in between the Months, but is there some other way to get this working? I can't use or < because the Month's are text only. -- [1] The SumProduct function should implicitly coerce the truth values to their Excel numeric equivalents. [2] The lookup functions should have an optional argument for the return value, defaulting to #N/A in its absence. |
All times are GMT +1. The time now is 09:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com