MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.
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.


Posted by Rickey Bowers Jr. on February 21, 2001 11:12 AM

I solved it :) Control-Shift-Enter, duh!
Thank you very much,
Rickey