BeginnerStatistical Functions
Count the headcount in one department
Count how many people sit in a single department on a staff list.
COUNTIF
4 min10 points
Real situations from working spreadsheets — sales targets, commission tiers, messy exports, aged invoices. Numbered in recommended order: start at 1 and work down, or filter to what you need.
1 exercise — Statistical Functions · for Human Resources
| # | Exercise | Functions | Difficulty | Time | Status |
|---|---|---|---|---|---|
| 9 | Count the headcount in one departmentHarbor Supply — staff list by department | COUNTIF | Beginner | 4 min | 10 pts |