sumproduct i think
 

Hello,

I'm struggling with what I think requires a sumproduct function but I can't
make it work and I'm going cross eyed...

I need to count the number of occurences of "x" in column c if the value in
column a = "text1" or "text2" but column b < "text3".


--
Any help appreciated,
MarkN

sumproduct i think
 

Hi Mark

Try the below
=SUMPRODUCT((ISNUMBER(MATCH(A1:A10,{"text1","text2 "},0)))*(B1:B10<"text3")*(C1:C10="x"))

If this post helps click Yes
---------------
Jacob Skaria


"MarkN" wrote:

Hello,

I'm struggling with what I think requires a sumproduct function but I can't
make it work and I'm going cross eyed...

I need to count the number of occurences of "x" in column c if the value in
column a = "text1" or "text2" but column b < "text3".


--
Any help appreciated,
MarkN

sumproduct i think
 

Try this...

=SUMPRODUCT(--(ISNUMBER(MATCH(A2:A20,{"text1","text2"},0))),--(B2:B20<"text3"),--(C2:C20="x"))

--
Biff
Microsoft Excel MVP


"MarkN" wrote in message
...
Hello,

I'm struggling with what I think requires a sumproduct function but I
can't
make it work and I'm going cross eyed...

I need to count the number of occurences of "x" in column c if the value
in
column a = "text1" or "text2" but column b < "text3".


--
Any help appreciated,
MarkN

sumproduct i think
 

Thanks very much Jacob,

Not only for the prompt reply but it works a treat.
--
Thanks,
MarkN


"Jacob Skaria" wrote:

Hi Mark

Try the below
=SUMPRODUCT((ISNUMBER(MATCH(A1:A10,{"text1","text2 "},0)))*(B1:B10<"text3")*(C1:C10="x"))

If this post helps click Yes
---------------
Jacob Skaria


"MarkN" wrote:

Hello,

I'm struggling with what I think requires a sumproduct function but I can't
make it work and I'm going cross eyed...

I need to count the number of occurences of "x" in column c if the value in
column a = "text1" or "text2" but column b < "text3".


--
Any help appreciated,
MarkN