Multiple text comparisons...

I have a small database in Excel, and I'd like to compare two values for certain equalities and return the count that are equal. Ex. The count of salesmen in California. I need to test both the title and the location fields and return the count of titles='Salesman' and location='California'. I'm sure I'm making this way harder than it is.
I've tried:
=SUM(IF(OFFSET(APs!$C$1,0,0,$D$2,1) & OFFSET(APs!$L$1,0,0,$D$2,1)="salesmanCalifornia",1))

as well as other stuff, and I'm just stumped :)

Thank you, Rickey

Even eye-opening awareness of abundant ignorance is appreciated.