combine 2 sumproduct formula's

[JWARD]

the following two formula's, how do i combine them into one?

=SUMPRODUCT(($A$15:$A$100="TRI-CITY")*($J$15:$J$100="1"))
=SUMPRODUCT(($B$15:$B$100="TRI-CITY")*($L$15:$L$100="1"))

thank you

 

[Joe4]

How about:

=SUMPRODUCT(($A$15:$A$100="TRI-CITY")*($J$15:$J$100="1")*($B$15:$B$100="TRI-CITY")*($L$15:$L$100="1"))

 

[JWARD]

got it, this worked

=SUMPRODUCT(($A$15:$A$100="TRI-CITY")*($J$15:$J$100="1")+($B$15:$B$100="TRI-CITY")*($L$15:$L$100="1"))

 

[Oaktree]

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&"|")))