software

I found a solution to my problem....

However, to designate quot;orquot; between multiple conditions existing in a
*single* range, you can create an array of these quot;orquot; conditions, using an
array constant, as:
=Sumproduct((Range1-{Condition1,Condition2,Condition3})*( ... )).

The above solution works IF I type in the conditions which are text...so
when I type in quot;Condition1quot; in quotes and quot;Condition2quot; in quotes it works as
I want it as an OR statement. However, when I try to put a cell reference as
the conditions where the cell reference is the actual text condition...it
does not work. Can anyone help? Thanks in advance.Something like

=SUMPRODUCT((ISNUMBER(MATCH(Range1,E1:E2,0))*(Rang e2)))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;Deedsquot; gt; wrote in message
...
gt; I found a solution to my problem....
gt;
gt; However, to designate quot;orquot; between multiple conditions existing in a
gt; *single* range, you can create an array of these quot;orquot; conditions, using an
gt; array constant, as:
gt; =Sumproduct((Range1-{Condition1,Condition2,Condition3})*( ... )).
gt;
gt; The above solution works IF I type in the conditions which are text...so
gt; when I type in quot;Condition1quot; in quotes and quot;Condition2quot; in quotes it works
as
gt; I want it as an OR statement. However, when I try to put a cell reference
as
gt; the conditions where the cell reference is the actual text condition...it
gt; does not work. Can anyone help? Thanks in advance.
gt;
Works....thanks much!
Followup: why do I use the quot;ISNUMBERquot; when the criteria is text?....
thanks for your help.

quot;Bob Phillipsquot; wrote:

gt; Something like
gt;
gt; =SUMPRODUCT((ISNUMBER(MATCH(Range1,E1:E2,0))*(Rang e2)))
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove xxx from email address if mailing direct)
gt;
gt; quot;Deedsquot; gt; wrote in message
gt; ...
gt; gt; I found a solution to my problem....
gt; gt;
gt; gt; However, to designate quot;orquot; between multiple conditions existing in a
gt; gt; *single* range, you can create an array of these quot;orquot; conditions, using an
gt; gt; array constant, as:
gt; gt; =Sumproduct((Range1-{Condition1,Condition2,Condition3})*( ... )).
gt; gt;
gt; gt; The above solution works IF I type in the conditions which are text...so
gt; gt; when I type in quot;Condition1quot; in quotes and quot;Condition2quot; in quotes it works
gt; as
gt; gt; I want it as an OR statement. However, when I try to put a cell reference
gt; as
gt; gt; the conditions where the cell reference is the actual text condition...it
gt; gt; does not work. Can anyone help? Thanks in advance.
gt; gt;
gt;
gt;
gt;

The ISNUMBER does not refer to the value being tested, but the result of the
MATCYH function. If the Match finds a MATCH, it returns a numeric index,
else it returns an error. ISNUMBER measures that.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;Deedsquot; gt; wrote in message
...
gt; Works....thanks much!
gt; Followup: why do I use the quot;ISNUMBERquot; when the criteria is text?....
gt; thanks for your help.
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Something like
gt; gt;
gt; gt; =SUMPRODUCT((ISNUMBER(MATCH(Range1,E1:E2,0))*(Rang e2)))
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove xxx from email address if mailing direct)
gt; gt;
gt; gt; quot;Deedsquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; I found a solution to my problem....
gt; gt; gt;
gt; gt; gt; However, to designate quot;orquot; between multiple conditions existing in a
gt; gt; gt; *single* range, you can create an array of these quot;orquot; conditions,
using an
gt; gt; gt; array constant, as:
gt; gt; gt; =Sumproduct((Range1-{Condition1,Condition2,Condition3})*( ... )).
gt; gt; gt;
gt; gt; gt; The above solution works IF I type in the conditions which are
text...so
gt; gt; gt; when I type in quot;Condition1quot; in quotes and quot;Condition2quot; in quotes it
works
gt; gt; as
gt; gt; gt; I want it as an OR statement. However, when I try to put a cell
reference
gt; gt; as
gt; gt; gt; the conditions where the cell reference is the actual text
condition...it
gt; gt; gt; does not work. Can anyone help? Thanks in advance.
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;