Forum Discussion
COUNTIF function
Hi there,
I am trying to count the number of job titles we have in my organization but because the job titles have more than 1 word I am having challenges using the COUNTIF function. What syntax should I be using? Is there a better function I can use?
I am on Windows 10 on a Thinkpad.
Thanks
6 Replies
Could you please clarify, if you have job titles like
Managing Director
Technical Director
would you like to count how many directors do you have; or how many managing/technical directors separately?
- Thanks @sergi.
I have titles like the foolowing:
Account Maintenance Specialist
Account Officer
Accountant
Accountant, Accounts Receivable
Accounting Coordinator
AML Officer
Analyst, Product Risk and Research
and need to count how many of each I have among about 800 employees.When it likes
=COUNTIF(list, "Analyst, Product Risk and Research")but much better in this case to create PivotTable to count each of existing positions
What exactly do you want to accomplish?
If you’re looking to ask a question or start a conversation about Excel, you’re in the right place!
Please include the following info to help others answer your question:
- Device and OS platform, e.g., PC/Windows 10 (see Which version of Windows operating system am I running?) or Mac/macOS Big Sur 11.2.1 (see Find out which macOS your Mac is using)
- Excel product name and version number (see About Office: What version of Office am I using?)
- Excel file you’re working with – please remove all confidential and PII data
- As much context of what you're trying to do - and why - as possible, e.g., how what you're trying to do fits into what larger process or workflow*
Once you got a good answer to your question, please accept it as solution to help others looking for answer to the same/similar question.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
