Need help with Countif function

[Guest]

This way worked for me, i had to use it on a spreed sheet i was doing.
ISNUMBER gives true/false and so does B1:B10="Closed". So instead of
adding those together, multiply (true*true=1,true*false=0,ect.), so it would
look like this :

=SUMPRODUCT(ISNUMBER(SEARCH("this",A3:A30))*(J3:J30="closed"))

That is just an example, "this" being part of the line like your XX or YY,
and "closed" being the exact line.

Hope this brings you closer to your conclusion! : )

 

[Guest]

Thanks so much. This is a great forum.