Count Allergy Alerts
I need to count how many students in 'Grade 5' have 'Peanut Allergy'. This helps me quickly identify students at risk for a specific allergen within a particular grade level for emergency preparedness.
=COUNTIFS(B2:B10, "Grade 5", C2:C10, "Peanut Allergy") How it works: The COUNTIFS function allows you to count cells that meet multiple criteria simultaneously. In this scenario, it counts rows where the 'Grade' column (B2:B10) matches 'Grade 5' AND the 'Allergy Type' column (C2:C10) matches 'Peanut Allergy'. This provides a precise count for critical health management and emergency planning.
Data Setup
| Student Name | Grade | Allergy Type | Emergency Contact |
|---|---|---|---|
| Alice Smith | Grade 5 | Peanut Allergy | 555-1111 |
| Bob Johnson | Grade 4 | None | 555-2222 |
| Charlie Brown | Grade 5 | Dairy Allergy | 555-3333 |
| Diana Prince | Grade 5 | Peanut Allergy | 555-4444 |
| Eve Adams | Grade 6 | Peanut Allergy | 555-5555 |
| Frank White | Grade 5 | None | 555-6666 |
| Grace Lee | Grade 4 | Peanut Allergy | 555-7777 |
| Henry King | Grade 5 | Peanut Allergy | 555-8888 |
| Ivy Green | Grade 6 | None | 555-9999 |
Step-by-Step Guide
Open your student health record spreadsheet in Excel.
Identify the column containing 'Grade' (e.g., Column B) and the column containing 'Allergy Type' (e.g., Column C).
In an empty cell where you want the count to appear, type the COUNTIFS formula: `=COUNTIFS(B2:B10, "Grade 5", C2:C10, "Peanut Allergy")`.
Press Enter to see the total count of students in Grade 5 who have a Peanut Allergy.