Need help with Countif function

R

Robert Brown

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! : )
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top