You're an HR analyst rolling up the company directory. Columns A–C contain EmployeeID, Name, and Department for 18 employees.
The four department names are already laid out in column E (E2=Engineering, E3=Sales, E4=Marketing, E5=HR) and the Headcount header sits in F1.
Your task:
- In column F (Headcount), return the number of employees in each department using COUNTIFS against column C.
Graded cells: F2 (Engineering), F4 (Marketing), F5 (HR).
Open this problem on a desktop to attempt it.