0done
MG
Meridian Group
Count employees by department
You're preparing a headcount report. You need to count all active employees in the Engineering department.
COUNTIFSBeginner . 3 min . HR & Operations
Lesson 2 · COUNTIFS
Count employees by department
Beginner~3 min
Learning objective
Practice using COUNTIFS 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.
Scenario
You're preparing a headcount report. You need to count all active employees in the Engineering department.
Goal
Write a COUNTIFS formula that counts rows where column B (Department) is "Engineering" and column C (Status) is "Active".
How COUNTIFS works
COUNTIFS counts cells across multiple ranges that satisfy all of the criteria simultaneously. You list pairs of (range, criterion). Every condition must be true (AND logic) for a row to be counted.
Syntax
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)Stuck? Reveal the hint
Try the formula first. Hints cost CP for a reason.
Loading workbook…