If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"OR" operator to evaluate multiple conditions
Is there an arithmetic operator that represents "OR" for use in functions such as SUMPRODUCT? I am aware that you may use the "*" operator in SUMPRODUCT to represent an "AND" as in the following case: =SUMPRODUCT((Condition1)*(Condition2)). What is the appropriate operator to evaluate "OR" instead of "AND"?
|
#2
|
|||
|
|||
"OR" operator to evaluate multiple conditions
Hi
I think an OR is usually done by adding two conditions, but it depends on the circumstances. Another alternative is to have 2 SUMPRODUCTS and add them together. =SUMPRODUUCT((OptionA=1)*(value))+SUMPRODUCT((Opti onA=2)*(value)) -- Andy. "Scott P" wrote in message ... Is there an arithmetic operator that represents "OR" for use in functions such as SUMPRODUCT? I am aware that you may use the "*" operator in SUMPRODUCT to represent an "AND" as in the following case: =SUMPRODUCT((Condition1)*(Condition2)). What is the appropriate operator to evaluate "OR" instead of "AND"? |
#3
|
|||
|
|||
"OR" operator to evaluate multiple conditions
Scott
It's + -- Best Regards Leo Heuser Followup to newsgroup only please. "Scott P" skrev i en meddelelse ... Is there an arithmetic operator that represents "OR" for use in functions such as SUMPRODUCT? I am aware that you may use the "*" operator in SUMPRODUCT to represent an "AND" as in the following case: =SUMPRODUCT((Condition1)*(Condition2)). What is the appropriate operator to evaluate "OR" instead of "AND"? |
#4
|
|||
|
|||
"OR" operator to evaluate multiple conditions
Thank you Leo and Andy -- I appreciate your help.
-Scott "Leo Heuser" wrote: Scott It's + -- Best Regards Leo Heuser Followup to newsgroup only please. "Scott P" skrev i en meddelelse ... Is there an arithmetic operator that represents "OR" for use in functions such as SUMPRODUCT? I am aware that you may use the "*" operator in SUMPRODUCT to represent an "AND" as in the following case: =SUMPRODUCT((Condition1)*(Condition2)). What is the appropriate operator to evaluate "OR" instead of "AND"? |
#5
|
|||
|
|||
"OR" operator to evaluate multiple conditions
The plus sign can be used to designate "or" between multiple conditions
existing in *multiple ranges*: =Sumproduct((Range1-Condition1)+(Range2-Condition2)*( ... )) However, to designate "or" between multiple conditions existing in a *single* range, you can create an array of these "or" conditions, using an array constant, as: =Sumproduct((Range1-{Condition1,Condition2,Condition3})*( ... )) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Scott P" wrote in message ... Thank you Leo and Andy -- I appreciate your help. -Scott "Leo Heuser" wrote: Scott It's + -- Best Regards Leo Heuser Followup to newsgroup only please. "Scott P" skrev i en meddelelse ... Is there an arithmetic operator that represents "OR" for use in functions such as SUMPRODUCT? I am aware that you may use the "*" operator in SUMPRODUCT to represent an "AND" as in the following case: =SUMPRODUCT((Condition1)*(Condition2)). What is the appropriate operator to evaluate "OR" instead of "AND"? |
#6
|
|||
|
|||
"RagDyeR" wrote...
The plus sign can be used to designate "or" between multiple conditions existing in *multiple ranges*: =Sumproduct((Range1-Condition1)+(Range2-Condition2)*( ... )) ... If both conditions are met, this double counts/sums (...). Safer to use =SUMPRODUCT(--((Condition1)+...+(ConditionN)0),(...)) -- To top-post is human, to bottom-post and snip is sublime. |
#7
|
|||
|
|||
"OR" operator to evaluate multiple conditions
You're welcome Scott, and we appreciate
your feedback :-) LeoH "Scott P" skrev i en meddelelse ... Thank you Leo and Andy -- I appreciate your help. -Scott |
#8
|
|||
|
|||
"OR" operator to evaluate multiple conditions
If more than 2 conditions involved, it pays to switch to...
=SUMPRODUCT(--ISNUMBER(MATCH(Range1,ConditionList,0)),...) "Scott P" wrote in message ... Is there an arithmetic operator that represents "OR" for use in functions such as SUMPRODUCT? I am aware that you may use the "*" operator in SUMPRODUCT to represent an "AND" as in the following case: =SUMPRODUCT((Condition1)*(Condition2)). What is the appropriate operator to evaluate "OR" instead of "AND"? |
#9
|
|||
|
|||
What does a minus sign do? is this a "but not"
anand "Leo Heuser" wrote: Scott It's + -- Best Regards Leo Heuser Followup to newsgroup only please. "Scott P" skrev i en meddelelse ... Is there an arithmetic operator that represents "OR" for use in functions such as SUMPRODUCT? I am aware that you may use the "*" operator in SUMPRODUCT to represent an "AND" as in the following case: =SUMPRODUCT((Condition1)*(Condition2)). What is the appropriate operator to evaluate "OR" instead of "AND"? |
#10
|
|||
|
|||
see other question.
-- HTH RP (remove nothere from the email address if mailing direct) "anand" wrote in message ... What does a minus sign do? is this a "but not" anand "Leo Heuser" wrote: Scott It's + -- Best Regards Leo Heuser Followup to newsgroup only please. "Scott P" skrev i en meddelelse ... Is there an arithmetic operator that represents "OR" for use in functions such as SUMPRODUCT? I am aware that you may use the "*" operator in SUMPRODUCT to represent an "AND" as in the following case: =SUMPRODUCT((Condition1)*(Condition2)). What is the appropriate operator to evaluate "OR" instead of "AND"? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
return results based on multiple conditions | Drabbacs | Worksheet Functions | 3 | May 28th, 2004 11:34 PM |
Multiple Conditions and Multiple Solutions | Frank Kabel | Worksheet Functions | 0 | February 4th, 2004 09:22 PM |
Excel Help - Counting Multiple Conditions & Multiple Values | MAX258 | Worksheet Functions | 5 | October 13th, 2003 09:40 PM |