How To Calculate Average Attendance Of Students: Formula & Examples 

To calculate average attendance, divide the total classes attended by the total possible classes, then multiply by 100.

Average Attendance (%) = Total Classes Attended ÷ Total Possible Classes × 100

For example:

45 ÷ 50 × 100 = 90%

So, the student’s average attendance is 90%.

Here, 45 is the number of classes the student attended. 50 is the total number of classes held. The result shows how often the student was present.

What Is Average Student Attendance?

Average student attendance shows how often a student or group of students attends classes. It is usually shown as a percentage.

Individual student attendance shows one student’s record. Average attendance percentage can show the average for several students. Overall class attendance looks at all students and their total attendance. Attendance rate tells you how often students were present.

Individual Student Attendance

For one student, divide the classes attended by the total classes held and multiply by 100.

Class or Group Attendance

For several students, add their attended classes and compare them with the total possible classes. This gives the overall class attendance rate.

Average Attendance Formula

The basic formula is:

Attendance Percentage = Classes Attended ÷ Classes Held × 100

• Classes attended: Classes the student was present for.
• Classes held: Total classes the student could attend.
• × 100: Changes the answer into a percentage.
• Final percentage: Shows the student’s attendance rate.

For a broader explanation of attendance percentages, see our guide on how to calculate attendance percentage.

Formula Using Present and Absent Days

You can also use:

Attendance % = Days Present ÷ (Days Present + Days Absent) × 100

Use this formula when your attendance record shows present and absent days instead of class counts.

How to Calculate Student Attendance Step by Step

Step 1: Count Total Classes or Working Days

Find the total number of classes held or working days included in the attendance record.

Step 2: Count Classes or Days Attended

Count how many classes or days the student was present.

Step 3: Divide Attended by Total

Divide the attended classes by the total classes.

Step 4: Multiply by 100

Multiply the result by 100 to get the attendance percentage.

Step 5: Check and Round the Result

Check your numbers first. Then round the answer if needed.

Example of Student Attendance Calculation

Suppose a student has:

• Total classes: 60
• Classes attended: 51
• Classes missed: 9

Now calculate:

51 ÷ 60 × 100 = 85%

So, the student’s attendance is 85%.

If you want to check the result without doing the math by hand, use our attendance calculator to calculate your attendance percentage quickly.

Example Using Present and Absent Days

Suppose a student was:

• Present: 40 days
• Absent: 10 days

Total days = 40 + 10 = 50

Now calculate:

40 ÷ 50 × 100 = 80%

The student’s attendance is 80%.

How to Calculate Average Attendance for Multiple Students

To calculate the average attendance for multiple students, first decide whether you need the average of their percentages or the overall class attendance. These can give different answers when students have different numbers of classes.

For example:

Here, each student has 20 classes. Their attendance percentages are easy to compare.

If you need average attendance for multiple students, you can average their percentages. If you need the overall student attendance, use total attended classes and total possible classes.

How to Average Student Attendance Percentages

The simple method is to add all attendance percentages and divide the total by the number of students.

For example:

90% + 80% + 75% + 95% = 340%

Then:

340 ÷ 4 = 85%

So, the average attendance percentage is 85%.

This method works when you are asked to find the average of the attendance percentages themselves.

Simple Average Formula

Average = Sum of Attendance Percentages ÷ Number of Students

For example, if four students have attendance of 90%, 80%, 75%, and 95%, their simple average is 85%.

How to Calculate Overall Class Attendance

For overall class attendance, divide the total classes attended by all students by the total possible classes, then multiply by 100.

Using the table above:

• Ali attended 18 classes
• Sara attended 16 classes
• Ahmed attended 15 classes

Total attended:

18 + 16 + 15 = 49

Total possible classes:

20 + 20 + 20 = 60

Now calculate:

49 ÷ 60 × 100 = 81.67%

So, the overall class attendance is 81.67%.

This method uses every attendance opportunity. It is useful when you want the true attendance rate for the whole class.

Overall Attendance Example

If 10 students could attend 20 classes each, there were:

10 × 20 = 200 possible attendances

If they attended 170 classes:

170 ÷ 200 × 100 = 85%

The overall attendance rate is 85%.

Simple Average vs Weighted Average Attendance

The two methods can give different results. The difference becomes clear when students have different numbers of classes.

What Is a Simple Average?

A simple average gives every student’s percentage the same weight.

Simple Average = Total Student Percentages ÷ Number of Students

For example:

• Student A = 100%
• Student B = 50%

100% + 50% = 150%

150% ÷ 2 = 75%

The simple average is 75%.

What Is a Weighted Average?

A weighted average considers how many classes each student could attend.

This matters when students have different numbers of classes. A student with 100 possible classes should have more effect on the overall rate than a student with only 10.

Example of Why the Results Can Differ

Student A

• 10 classes
• 10 attended
• 100% attendance

Student B

• 100 classes
• 50 attended
• 50% attendance

Simple average:

(100% + 50%) ÷ 2 = 75%

But the overall attendance is:

60 ÷ 110 × 100 = 54.55%

So, 75% is the simple average, while 54.55% is the overall attendance rate.

Which Method Should You Use?

Use the simple average when you need the average of student percentages and each student has the same number of possible classes.

Use total attended ÷ total possible × 100 when students have different numbers of possible classes and you need the overall attendance rate.

How to Calculate Average Attendance in Excel

Excel can make attendance calculation much faster, especially when you have many students.

Calculate One Student’s Attendance in Excel

Suppose:

• B2 = Classes Attended
• C2 = Total Classes

Use:

=B2/C2*100

For example, if B2 is 18 and C2 is 20, Excel gives 90%.

Average Several Attendance Percentages

If attendance percentages are in cells D2 through D11, use:

=AVERAGE(D2:D11)

This finds the simple average of the percentages.

Calculate Overall Class Attendance in Excel

If:

• B2:B11 contains classes attended
• C2:C11 contains total possible classes

Use:

=SUM(B2:B11)/SUM(C2:C11)*100

This calculates the overall class attendance from the total numbers.

Create an Attendance Table in Excel

You can add the attendance formula in the last column and copy it down for each student.

Calculate Attendance From a CSV File

If your school system gives you an attendance CSV, open the file in Excel. Check which columns contain attended classes, total classes, or attendance percentages. Then use the matching Excel formula to calculate the result.

This is useful for large attendance records because you don’t have to calculate each student by hand.

How to Calculate Average Monthly Attendance

To calculate monthly attendance, divide the days present by the total working days, then multiply by 100.

Calculate Attendance for One Month

Suppose a student has 22 working days in a month and is present for 20 days.

20 ÷ 22 × 100 = 90.91%

So, the student’s monthly attendance percentage is 90.91%.

Only count days that were scheduled for attendance. Holidays and other non-working days shouldn’t be added to the total.

Calculate Average Attendance Across Several Months

You can calculate attendance for each month, but don’t always add the monthly percentages and divide by the number of months.

For example, if one month has 20 working days and another has 25, the two months don’t have the same number of attendance opportunities.

For an accurate overall rate, add all days present and divide by all working days.

How to Calculate Semester or Yearly Attendance

Semester or yearly attendance uses the same basic formula. Add all attended classes or days, divide by all possible classes or working days, then multiply by 100.

Semester Attendance

Add the student’s attended classes for the semester. Then divide them by the total classes held during that semester.

Semester Attendance = Total Classes Attended ÷ Total Classes Held × 100

Yearly Attendance

For yearly attendance, combine the attendance records from the full academic year.

For example, if a student attended 450 out of 500 possible classes:

450 ÷ 500 × 100 = 90%

The yearly attendance is 90%.

Why You Should Not Always Average Monthly Percentages

A simple average can give the wrong overall result when months have different numbers of classes.

The safer method is:

Total Attended ÷ Total Possible × 100

This gives more weight to months with more attendance opportunities.

As a BSCS student, I find this method especially useful when working with larger attendance records in spreadsheets. A small formula error can change the final percentage, so checking the total classes first saves trouble.

How to Calculate 75% Attendance

To find the number of classes needed for 75% attendance, multiply the total classes by 0.75.

Required attended classes = Total Classes × 0.75

For example:

100 × 0.75 = 75 classes

So, a student must attend 75 out of 100 classes to have 75% attendance.

Need to check your own 75% attendance requirement? Use our 75% attendance calculator to see how many classes you need to attend or can miss.

How Many Classes Can You Miss With 75% Attendance?

With 100 total classes, you need to attend 75.

100 – 75 = 25

So, you can miss 25 classes and still have 75% attendance.

This works when all 100 classes are part of the attendance total.

How Many Classes Must You Attend to Reach 75% Attendance?

Suppose you’ve already attended 50 out of 80 classes and want to reach 75%.

Let the extra classes you need to attend be x:

(50 + x) ÷ (80 + x) = 0.75

Solving this gives:

x = 40

So, you need to attend the next 40 classes without missing one to reach 75%.

Common Student Attendance Calculation Mistakes

Counting Absent Days as Attended

Mistake: Adding absent days to attended days.

Fix: Count only the days or classes where the student was present.

Using the Wrong Total Number of Classes

Mistake: Using the full school calendar instead of actual classes held.

Fix: Use the classes or working days that were actually scheduled.

Including Holidays Incorrectly

Mistake: Counting holidays as missed attendance.

Fix: Leave holidays out if students weren’t expected to attend.

Averaging Percentages When Class Counts Differ

Mistake: Averaging percentages from months or students with different class totals.

Fix: Use total attended ÷ total possible for the overall rate.

Rounding Too Early

Mistake: Rounding each monthly result before calculating the yearly result.

Fix: Keep the original numbers and round the final answer.

Mixing Classes and Working Days

Mistake: Using class attendance in one part and working days in another.

Fix: Use the same type of attendance data throughout the calculation.

Forgetting Partial Attendance

Mistake: Treating a partly attended class as a full absence or full attendance when your school’s rules use partial attendance.

Fix: Follow the attendance rules used by your school or college.

Student Attendance Formula Quick Reference

For most overall class calculations, total attended ÷ total possible × 100 gives the clearest result.

Frequently Asked Questions About Average Student Attendance

How do you calculate average attendance of students?

Divide the total classes attended by the total possible classes and multiply by 100. For several students, use total attended classes divided by total possible classes when you need the overall attendance rate.

What is the formula for average attendance?

Average Attendance (%) = Total Classes Attended ÷ Total Possible Classes × 100

How do you calculate attendance percentage?

Attendance Percentage = Classes Attended ÷ Classes Held × 100

For day-based records, you can use Days Present ÷ (Days Present + Days Absent) × 100.

How do you calculate average attendance for a class?

Add the classes attended by all students. Then divide that number by the total possible attendance and multiply by 100.

Can you average student attendance percentages?

Yes, when you specifically need the average of the percentages. If students have different numbers of possible classes, use total attended divided by total possible for the overall attendance rate.

How do you calculate average attendance in Excel?

For one student’s attendance, use:

=B2/C2*100

For several attendance percentages, use:

=AVERAGE(D2:D11)

How do you calculate monthly average attendance?

Add the days present for the month, divide by the total working days, and multiply by 100.

Monthly Attendance = Days Present ÷ Working Days × 100

How do you calculate 75% attendance?

Multiply the total number of classes by 0.75.

For 100 classes:

100 × 0.75 = 75 classes

You need to attend 75 classes.

What is the difference between average attendance and attendance percentage?

Attendance percentage usually shows how often a student or group was present. Average attendance can mean the average of several attendance percentages or the overall attendance rate, depending on the calculation used.

What is the easiest way to calculate student attendance?

A spreadsheet is useful for a small or large attendance record. You can also use an attendance calculator to reduce manual calculation errors.

Final Answer: How to Calculate Average Attendance of Students

Average Attendance (%) = Total Classes Attended ÷ Total Possible Classes × 100

For multiple students with different numbers of possible classes, total attended ÷ total possible × 100 is generally the better way to find the overall attendance rate.