software

Hi all. I am trying to count the number of occurrences of a set of
conditions in my table, but with one of the criteria including 2 conditions.
My current formula is:
=SUMPRODUCT(--(H3:H50=quot;FLINDERSquot;),--(J3:J50=quot;MODERATEquot;),--(B3:B50=quot;STRAT
6quot;),--(K3:K50={quot;ALLOCATEDquot;,quot;CONSIDERquot;}))

However, this produces a #value answer. If I simplify it to just have one
condition in the last set (e.g.
=SUMPRODUCT(--(H3:H50=quot;FLINDERSquot;),--(J3:J50=quot;MODERATEquot;),--(B3:B50=quot;STRAT
6quot;),--(K3:K50=quot;ALLOCATEDquot;))
everything works fine and it will return the number of rows that meet this
criteria.
How can I make it work so that it will count rows that have quot;allocatedquot; or
quot;considerquot; as the third condition?
Help appreciated - it's been driving me nuts!!
Oh for a 'not equal to' sign on the keyboard or in excel!!!
Thanks in advance to anyone who can help.
Steve

--
Stef

Hi

=SUMPRODUCT(--(H3:H50=quot;FLINDERSquot;),--(J3:J50=quot;MODERATEquot;),--(B3:B50=quot;STRAT
6quot;),(K3:K50=quot;ALLOCATEDquot;) (K3:K50=quot;CONSIDERquot;))--
Arvi Laanemets
( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
quot;Stefanquot; gt; wrote in message
...
gt; Hi all. I am trying to count the number of occurrences of a set of
gt; conditions in my table, but with one of the criteria including 2
gt; conditions.
gt; My current formula is:
gt; =SUMPRODUCT(--(H3:H50=quot;FLINDERSquot;),--(J3:J50=quot;MODERATEquot;),--(B3:B50=quot;STRAT
gt; 6quot;),--(K3:K50={quot;ALLOCATEDquot;,quot;CONSIDERquot;}))
gt;
gt; However, this produces a #value answer. If I simplify it to just have one
gt; condition in the last set (e.g.
gt; =SUMPRODUCT(--(H3:H50=quot;FLINDERSquot;),--(J3:J50=quot;MODERATEquot;),--(B3:B50=quot;STRAT
gt; 6quot;),--(K3:K50=quot;ALLOCATEDquot;))
gt; everything works fine and it will return the number of rows that meet this
gt; criteria.
gt; How can I make it work so that it will count rows that have quot;allocatedquot; or
gt; quot;considerquot; as the third condition?
gt; Help appreciated - it's been driving me nuts!!
gt; Oh for a 'not equal to' sign on the keyboard or in excel!!!
gt; Thanks in advance to anyone who can help.
gt; Steve
gt;
gt; --
gt; Stef
Thanks Arvi - works a treat!!
Steve
--
Stefquot;Arvi Laanemetsquot; wrote:

gt; Hi
gt;
gt; =SUMPRODUCT(--(H3:H50=quot;FLINDERSquot;),--(J3:J50=quot;MODERATEquot;),--(B3:B50=quot;STRAT
gt; 6quot;),(K3:K50=quot;ALLOCATEDquot;) (K3:K50=quot;CONSIDERquot;))
gt;
gt;
gt; --
gt; Arvi Laanemets
gt; ( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
gt;
gt;
gt;
gt; quot;Stefanquot; gt; wrote in message
gt; ...
gt; gt; Hi all. I am trying to count the number of occurrences of a set of
gt; gt; conditions in my table, but with one of the criteria including 2
gt; gt; conditions.
gt; gt; My current formula is:
gt; gt; =SUMPRODUCT(--(H3:H50=quot;FLINDERSquot;),--(J3:J50=quot;MODERATEquot;),--(B3:B50=quot;STRAT
gt; gt; 6quot;),--(K3:K50={quot;ALLOCATEDquot;,quot;CONSIDERquot;}))
gt; gt;
gt; gt; However, this produces a #value answer. If I simplify it to just have one
gt; gt; condition in the last set (e.g.
gt; gt; =SUMPRODUCT(--(H3:H50=quot;FLINDERSquot;),--(J3:J50=quot;MODERATEquot;),--(B3:B50=quot;STRAT
gt; gt; 6quot;),--(K3:K50=quot;ALLOCATEDquot;))
gt; gt; everything works fine and it will return the number of rows that meet this
gt; gt; criteria.
gt; gt; How can I make it work so that it will count rows that have quot;allocatedquot; or
gt; gt; quot;considerquot; as the third condition?
gt; gt; Help appreciated - it's been driving me nuts!!
gt; gt; Oh for a 'not equal to' sign on the keyboard or in excel!!!
gt; gt; Thanks in advance to anyone who can help.
gt; gt; Steve
gt; gt;
gt; gt; --
gt; gt; Stef
gt;
gt;
gt;