Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I use OR function inside SUMIFS
I asked thsi question last week and thanks Luke M for his kind interest.
However it did not solve my problem for example I'm writing SUMIFS(long and 4-5 ciriterias). But in one cirteria I need to say "OR" A long way is I write SUMIFS(...................................)+SUMIFS (.....................). I cant imagine if my need will be 3-4 ORs : ) Best wishes, Baybora |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I use OR function inside SUMIFS
Hi,
Please post your formula and indicate where you need the or, thanks However you will need to use an if statement =if(or(A1=0,B1=3),sumifs(............... "Baybora" wrote: I asked thsi question last week and thanks Luke M for his kind interest. However it did not solve my problem for example I'm writing SUMIFS(long and 4-5 ciriterias). But in one cirteria I need to say "OR" A long way is I write SUMIFS(...................................)+SUMIFS (.....................). I cant imagine if my need will be 3-4 ORs : ) Best wishes, Baybora |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I use OR function inside SUMIFS
Hello again!
Another way to get an OR type function with summation, is to multiply your values against some "criteria arrays". When you do this, make sure you're crtieria are not over lapping (eg x5, x10) Let's say you want to sum column D when column A = "Tom" or column B = "Bob" and column C = "Smith" =SUMPRODUCT(--(((A:A="Tom")+(B:B="Bob"))0),(C:C="Smith"),(D:D)) Note how the "or" criteria are added together, while the additional criteria is seperated by a column. The "0" check is in there for the cases when both A and B equal their criteria. For other readers, note that SUMPRODUCT can only callout entire columns (A:A) when using XL 2007. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Baybora" wrote: I asked thsi question last week and thanks Luke M for his kind interest. However it did not solve my problem for example I'm writing SUMIFS(long and 4-5 ciriterias). But in one cirteria I need to say "OR" A long way is I write SUMIFS(...................................)+SUMIFS (.....................). I cant imagine if my need will be 3-4 ORs : ) Best wishes, Baybora |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I use OR function inside SUMIFS
Hallo Master Luke M,
I had started with sumproduct but again I could not pass this OR mountain pass. Then I had deceided to use SUMIF solution and met the same rock again. This magic 0 solved my problem. Really thank you. And also thanks Eduardo for kind his interest. Best wishes, Baybora "Luke M" wrote: Hello again! Another way to get an OR type function with summation, is to multiply your values against some "criteria arrays". When you do this, make sure you're crtieria are not over lapping (eg x5, x10) Let's say you want to sum column D when column A = "Tom" or column B = "Bob" and column C = "Smith" =SUMPRODUCT(--(((A:A="Tom")+(B:B="Bob"))0),(C:C="Smith"),(D:D)) Note how the "or" criteria are added together, while the additional criteria is seperated by a column. The "0" check is in there for the cases when both A and B equal their criteria. For other readers, note that SUMPRODUCT can only callout entire columns (A:A) when using XL 2007. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Baybora" wrote: I asked thsi question last week and thanks Luke M for his kind interest. However it did not solve my problem for example I'm writing SUMIFS(long and 4-5 ciriterias). But in one cirteria I need to say "OR" A long way is I write SUMIFS(...................................)+SUMIFS (.....................). I cant imagine if my need will be 3-4 ORs : ) Best wishes, Baybora |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use or funcition inside sumifs functiıon ? | Excel Discussion (Misc queries) | |||
sumifs function | Excel Discussion (Misc queries) | |||
Sumifs function | Excel Worksheet Functions | |||
SUMIFS function help | Excel Discussion (Misc queries) | |||
Can SUMIFS use the OR function? | Excel Worksheet Functions |