Monitor High-Risk Patients in Ward
I need to count how many patients in 'ICU-A' currently have a heart rate above 100 bpm.
=COUNTIFS(B2:B8,"ICU-A",C2:C8,">100") How it works: The COUNTIFS function is used to count cells that meet multiple criteria. In this formula, `B2:B8` is the range for the 'Ward/Unit' column, and `"ICU-A"` is the first criterion, ensuring only patients in 'ICU-A' are considered. `C2:C8` is the range for the 'Heart Rate (bpm)' column, and `">100"` is the second criterion, filtering for patients with a heart rate strictly greater than 100 bpm. The function then returns the total number of patients that satisfy both conditions simultaneously.
Data Setup
| Patient ID | Ward/Unit | Heart Rate (bpm) | Status |
|---|---|---|---|
| P101 | ICU-A | 110 | Critical |
| P102 | ICU-B | 95 | Stable |
| P103 | ICU-A | 88 | Stable |
| P104 | ICU-A | 105 | Critical |
| P105 | ER | 120 | Urgent |
| P106 | ICU-A | 99 | Stable |
| P107 | ICU-A | 101 | Critical |
| P108 | ICU-B | 115 | Critical |
Step-by-Step Guide
Open your patient data spreadsheet in Excel.
Identify the column containing the 'Ward/Unit' information (e.g., Column B) and the column for 'Heart Rate (bpm)' (e.g., Column C).
In an empty cell where you want the count to appear, type the formula: `=COUNTIFS(B2:B8,"ICU-A",C2:C8,">100")`.
Press Enter to see the total count of patients meeting both criteria.