Attendance rate — days present over enrolled days — matters for ratios, food-program counts, and (for subsidies) reimbursement. It’s a COUNTIF over a daily attendance grid.
The example
17 present of 20 days.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | 17 / 20 | — |
| 3 | Attendance | → 85% |
The formula
The formula:
How it works
How it works:
- Count days present with
COUNTIF(row, "P")across the attendance grid. - Divide by enrolled days (scheduled days in the period) for the rate.
- Count absences with COUNTIF on “A” — the complement.
- For a group rate, total presents ÷ total enrolled-days with COUNTIFS.
Attendance feeds more than a report card. Daily presence drives food-program meal counts, ratio staffing, and — for subsidized children — reimbursement that often depends on documented attendance. A clean grid of P/A marks plus a couple of COUNTIF formulas gives per-child and per-room rates, and the same data populates your CACFP counts and subsidy claims without re-entry.
Try it: interactive demo
Days present and enrolled days.
Variations
Count present
From the grid:
Absence rate
The complement:
Group rate
Whole room:
Pitfalls & errors
Consistent marks. One symbol for present so COUNTIF matches.
Enrolled days. Use scheduled days, not calendar days.
Zero enrolled days. No days gives #DIV/0!.
Practice workbook
Frequently asked questions
How do I calculate attendance rate in Excel?
How do I get a whole-room rate?
Why does attendance matter beyond reports?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class