sumproduct i think

  • Thread starter Thread starter MarkN
  • Start date Start date
M

MarkN

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

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

If this post helps click Yes
 
Try this...

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