Count Patients Waiting > 2 Hours
I need to count patients where 'Status' is 'Waiting' and 'Wait Time' is greater than 120 minutes.
=COUNTIFS(B2:B11,"Waiting",C2:C11,">120") How it works: The COUNTIFS function is used to count cells that meet multiple criteria. In this scenario, it first checks the range B2:B11 for cells containing the text 'Waiting'. For every row that matches, it then checks the corresponding cell in the range C2:C11 to see if the value is greater than 120. Only rows that satisfy BOTH conditions are included in the final count. This allows the Triage Nurse to quickly identify patients requiring urgent attention due to prolonged wait times.
Data Setup
| "Patient ID" | "Status" | "Wait Time (minutes)" |
|---|---|---|
| "P001" | "Waiting" | 150 |
| "P002" | "Seen" | 60 |
| "P003" | "Waiting" | 90 |
| "P004" | "Waiting" | 180 |
| "P005" | "Waiting" | 100 |
| "P006" | "Seen" | 120 |
| "P007" | "Waiting" | 200 |
| "P008" | "Waiting" | 110 |
| "P009" | "Admitted" | 240 |
| "P010" | "Waiting" | 130 |
Step-by-Step Guide
Enter your patient data into an Excel sheet. Ensure you have columns for 'Status' (e.g., Column B) and 'Wait Time (minutes)' (e.g., Column C).
In an empty cell where you want the result to appear (e.g., D2), type the COUNTIFS formula: `=COUNTIFS(B2:B11,"Waiting",C2:C11,">120")`.
Press Enter. The cell will display the total count of patients whose status is 'Waiting' AND whose wait time exceeds 120 minutes.