Count Delayed Tasks by Team
As a Construction Scheduler, I need to quickly count how many tasks are currently marked 'Incomplete' and are specifically assigned to 'Team Alpha' across my project schedule. This helps me identify bottlenecks and reallocate resources efficiently.
=COUNTIFS(B2:B11,"Incomplete",C2:C11,"Team Alpha") How it works: The COUNTIFS function is used to count cells that meet multiple criteria. In this scenario, it first looks at the range B2:B11 and counts only those cells that contain 'Incomplete'. Then, from that filtered set, it further filters by checking if the corresponding cell in range C2:C11 contains 'Team Alpha'. Only rows that satisfy BOTH conditions are included in the final count, providing a precise number of incomplete tasks assigned to 'Team Alpha'.
Data Setup
| "Task ID" | "Status" | "Assigned Team" | "Due Date" |
|---|---|---|---|
| "T001" | "Complete" | "Team Alpha" | "2023-01-15" |
| "T002" | "Incomplete" | "Team Alpha" | "2023-01-20" |
| "T003" | "Complete" | "Team Beta" | "2023-01-25" |
| "T004" | "Incomplete" | "Team Gamma" | "2023-01-30" |
| "T005" | "Incomplete" | "Team Alpha" | "2023-02-05" |
| "T006" | "Complete" | "Team Alpha" | "2023-02-10" |
| "T007" | "Incomplete" | "Team Beta" | "2023-02-15" |
| "T008" | "Incomplete" | "Team Alpha" | "2023-02-20" |
| "T009" | "Complete" | "Team Gamma" | "2023-02-25" |
| "T010" | "Incomplete" | "Team Delta" | "2023-03-01" |
Step-by-Step Guide
Identify the range containing the 'Status' of your tasks. In the mock data, this is column B (B2:B11).
Specify the first criterion: the status you want to count, which is "Incomplete".
Identify the range containing the 'Assigned Team'. In the mock data, this is column C (C2:C11).
Specify the second criterion: the team you want to count, which is "Team Alpha".
Combine these into the COUNTIFS formula: `=COUNTIFS(B2:B11,"Incomplete",C2:C11,"Team Alpha")` and press Enter.