Count employees with specific title pattern
HR wants to know how many employees have "Manager" anywhere in their job title. Titles are in column C and include things like "Project Manager", "Senior Manager", and "Manager, Operations".
Count employees with specific title pattern
Practice using COUNTIF to solve a real hr & operations problem. By the end, you’ll know when to reach for it and how to structure the arguments correctly.
HR wants to know how many employees have "Manager" anywhere in their job title. Titles are in column C and include things like "Project Manager", "Senior Manager", and "Manager, Operations".
Write a COUNTIF formula that counts cells in C2:C500 containing the word "Manager" anywhere in the text. Use a wildcard.
COUNTIF counts the cells in a range that meet one condition. It's the fastest way to answer 'how many of these match that' - how many overdue invoices, how many East-region orders, how many entries above $1000. Supports wildcards (* and ?) and comparison operators in the criterion.
COUNTIF(range, criteria)Try the formula first. Hints cost CP for a reason.