Count Students with Perfect Attendance
I need to count students where 'Absences' is 0 and 'Tardies' is 0.
=COUNTIFS(B2:B7,0,C2:C7,0) How it works: The COUNTIFS function allows you to count cells that meet multiple criteria simultaneously. In this scenario, we are counting rows where the 'Absences' column equals 0 AND the 'Tardies' column also equals 0. Each pair of arguments in COUNTIFS specifies a range and its corresponding criterion. This efficiently identifies students who have neither missed a day nor been late, providing a quick metric for perfect attendance.
Data Setup
| Student Name | Absences | Tardies |
|---|---|---|
| Alice | 0 | 0 |
| Bob | 1 | 0 |
| Charlie | 0 | 1 |
| David | 0 | 0 |
| Eve | 2 | 1 |
| Frank | 0 | 0 |
Step-by-Step Guide
Open your student attendance tracking spreadsheet in Excel.
Identify the column containing 'Absences' (e.g., Column B) and the column containing 'Tardies' (e.g., Column C).
In an empty cell, type the COUNTIFS formula: `=COUNTIFS(B2:B7,0,C2:C7,0)` (adjust the ranges B2:B7 and C2:C7 to match your data's actual rows).
Press Enter to get the total count of students with perfect attendance.