Hi! I'm a stumped grad student. Any help is hugely appreciated!
I have this huge spreadsheet with demographic info on every nurse in Texas. Each row is an individual nurse. I need to determine how many work in urban and rural counties. One column on the sheet lists the county of practice for each nurse.
I've tried COUNTIFS but it keeps returning errors. It seems like this should be a simple formula but I am completely stumped!
Thanks again in advance for any assistance!
One way:Formula:
Please Login or Register to view this content.
Or, Array Entered:committed with Ctrl-Shift-Enter rather than just Enter, where F2:F4 contain the counties to be included in the countFormula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks