software

Hi,

My current formula works okay but I wish to add more complexity to it.
=SUMPRODUCT(--(Others!$A$2:$A$2000=$A2),--(Others!$B$2:$B$2000=quot;Uquot;),--(Others!$I$2:$I$2000=1),--(Others!$X$2:$X$2000))

where $A2 is the name of a product ( 1st array )
and Range Others!$B$2:$B$2000 contains data Q, A, AS, U, MAS

What I am wanting to do is extend the 2nd array to include any of the
following ( U, AS amp; MAS ). How do I do this ?

Cheers,
Bernz--
BernzG
------------------------------------------------------------------------
BernzG's Profile: www.excelforum.com/member.php...oamp;userid=22949
View this thread: www.excelforum.com/showthread...hreadid=540123Hi!

Try this:

=SUMPRODUCT(--(Others!$A$2:$A$2000=$A2),--(ISNUMBER(MATCH(Others!$B$2:$B$2000,{quot;Uquot;,quot;ASquot;,quot;MAS quot;},0))),--(Others!$I$2:$I$2000=1),Others!$X$2:$X$2000)

Biff

quot;BernzGquot; gt; wrote in
message ...
gt;
gt; Hi,
gt;
gt; My current formula works okay but I wish to add more complexity to it.
gt; =SUMPRODUCT(--(Others!$A$2:$A$2000=$A2),--(Others!$B$2:$B$2000=quot;Uquot;),--(Others!$I$2:$I$2000=1),--(Others!$X$2:$X$2000))
gt;
gt; where $A2 is the name of a product ( 1st array )
gt; and Range Others!$B$2:$B$2000 contains data Q, A, AS, U, MAS
gt;
gt; What I am wanting to do is extend the 2nd array to include any of the
gt; following ( U, AS amp; MAS ). How do I do this ?
gt;
gt; Cheers,
gt; Bernz
gt;
gt;
gt; --
gt; BernzG
gt; ------------------------------------------------------------------------
gt; BernzG's Profile:
gt; www.excelforum.com/member.php...oamp;userid=22949
gt; View this thread: www.excelforum.com/showthread...hreadid=540123
gt;

Hi Biff,

Thanks - that has worked perfectly--
BernzG
------------------------------------------------------------------------
BernzG's Profile: www.excelforum.com/member.php...oamp;userid=22949
View this thread: www.excelforum.com/showthread...hreadid=540123You're welcome. Thanks for the feedback!

Biff

quot;BernzGquot; gt; wrote in
message ...
gt;
gt; Hi Biff,
gt;
gt; Thanks - that has worked perfectly
gt;
gt;
gt; --
gt; BernzG
gt; ------------------------------------------------------------------------
gt; BernzG's Profile:
gt; www.excelforum.com/member.php...oamp;userid=22949
gt; View this thread: www.excelforum.com/showthread...hreadid=540123
gt;