Multiple text comparisons...
Posted by Rickey Bowers Jr. on February 21, 2001 11:01 AM
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.
=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.