"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"?

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"?

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"?

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"?

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"?

"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.

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

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"?

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"?

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"?