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
bunmi21
Jun 22, 2021Copper Contributor
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.
Lorenzo
Jun 22, 2021Silver Contributor
With a Pivot Table:
- Drop the Job Title to the Rows area
- Drop the Job Title to the Values area
Sample attached