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:J3 0="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! : )