Forum Discussion
bunmi21
Jun 22, 2021Copper Contributor
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 ...
- Jun 22, 2021
With a Pivot Table:
- Drop the Job Title to the Rows area
- Drop the Job Title to the Values areaSample attached
NikolinoDE
Jun 22, 2021Platinum Contributor
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)