Forum Discussion
Solved
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 ...
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.
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
- thank you very much.