Depends on what you mean. jmiskey's formula assumes you mean ALL of the 4 criteria must be met.
If you mean if EITHER pair is met, then try something like:
=SUMPRODUCT(--ISNUMBER(SEARCH("Tri-City",$A$15:$A$100&"|"&$B$15:$B$100)),--ISNUMBER(SEARCH("|1|","|"&$J$15:$J$100&"|"&$L$15:$L$100&"|")))