ZorantaGuides
Herebook

Herebook › Guides

Attendance Percentage Calculator: Formula, Examples and Excel

Attendance percentage = sessions attended ÷ sessions held × 100. A student who came to 18 of 24 classes has an attendance rate of 18 ÷ 24 × 100 = 75%.

The formula is the easy part. The answer changes depending on how you count late arrivals, excused absences and cancelled sessions, so decide those rules first and apply them the same way to everyone.

Potted plants of rising heights on a windowsill, like attendance rates growing month by month

The attendance percentage formula

ExampleAttendedHeldAttendance %
Weekly piano lesson, one term111211 ÷ 12 × 100 = 91.7%
Football training, twice a week for 8 weeks131613 ÷ 16 × 100 = 81.3%
University module182418 ÷ 24 × 100 = 75.0%
Whole group of 10 people, 4 sessions34 marks of Present40 person-sessions34 ÷ 40 × 100 = 85.0%

For a whole group, count person-sessions: the number of people on the roster multiplied by the number of sessions. A group of 10 that met 4 times has 40 places to fill. If 34 of them were filled, the group's rate for that period is 85%.

Herebook

Herebook works out this month's rate for each person and the whole group, and you choose whether Late counts as Present and whether Excused is left out. Get it on Google Play

Decide how late, excused and cancelled sessions count

Two people using the same formula can get different answers from the same register because they count these marks differently. Pick one rule for each and write it down.

MarkCommon choiceEffect on the rate
LateCounts as attended (they were there)Rate goes up compared with counting late as absent
ExcusedLeft out of both the top and bottom of the fractionAn excused absence does not pull the rate down
Excused, strict versionCounts as absentThe rate shows actual time in the room
Session cancelled by youNot counted at allNobody is marked absent for a class that did not happen
Blank (no mark yet)Not countedAvoids treating a forgotten mark as an absence

Example with excused absences left out

A dancer has 12 sessions in a term: 9 Present, 1 Late, 1 Excused and 1 Absent. Counting late as present and leaving excused out, the calculation is (9 + 1) ÷ (12 − 1) × 100 = 10 ÷ 11 × 100 = 90.9%. Counting excused as absent instead, it is 10 ÷ 12 × 100 = 83.3%.

Schools and universities usually set these rules in their own attendance policy. If a rate is used for a formal requirement, use the institution's definition rather than your own.

How many classes can I miss and stay above a minimum?

If a course needs a minimum rate, you can work out how many absences fit inside it.

  1. Multiply the total number of sessions by the minimum rate. For 40 sessions and a 75% minimum: 40 × 0.75 = 30.
  2. Round up to a whole session: you need to attend at least 30.
  3. Subtract from the total: 40 − 30 = 10 sessions can be missed.

If you are already partway through, use the sessions still to come. Say you have attended 14 of the first 20 and there are 20 left. To reach 30 in total, you need 16 of the remaining 20, so you can miss 4 more.

To find out how many sessions in a row it takes to climb back to a target, solve (attended + n) ÷ (held + n) ≥ target. From 14 of 20 (70%) to 75%: (14 + n) ÷ (20 + n) ≥ 0.75 gives n ≥ 4. Four sessions in a row bring the rate to 18 ÷ 24 = 75%.

Attendance percentage formula in Excel or Google Sheets

Put one person per row and one session per column, and type P, L, E or A in each cell. With the marks for one person in B2:M2:

What you wantFormula
Present only=COUNTIF(B2:M2,"P")/COUNTA(B2:M2)
Late counts as present=(COUNTIF(B2:M2,"P")+COUNTIF(B2:M2,"L"))/COUNTA(B2:M2)
Late counts, excused left out=(COUNTIF(B2:M2,"P")+COUNTIF(B2:M2,"L"))/(COUNTA(B2:M2)-COUNTIF(B2:M2,"E"))

Format the cell as a percentage instead of multiplying by 100. COUNTA counts only filled cells, so empty columns for future sessions do not lower the rate. For a cancelled session, leave the whole column blank or type a code such as X and subtract COUNTIF(B2:M2,"X") from the bottom of the fraction.

The spreadsheet route works, but it is easy to break a formula when you copy a row or add a column mid-term. Check one person by hand after any change to the layout.

Reading the numbers

Herebook

Let the rates add up as you take roll

With Herebook you mark Present, Absent, Late or Excused with one tap per person, and each person's page shows their rate month by month for the last six months.

Get it on Google Play

iPhone version coming soon

More guides

All guides

Published by Zoranta, the developer of Herebook.