How to Calculate Attendance Percentage in Excel (with Steps)


Step 1 – Creating a Dataset with Proper Parameters

  • Our sample dataset includes 7 students, the number of lectures delivered and the number of lectures they attended. We will calculate the percentage of delivered lectures attended by each student.

 Creating Data Set

Step 2 – Applying the Percentage Formula

Numerator/Denominator is the Excel formula for percentages, with the result multiplied by 100. In our example, for each student, the denominator is the number of lectures delivered, and the numerator is the number of those lectures attended.

  • Select the E5 cell.
  • Enter the following formula:
  • Press ENTER.

Applying Percentage Formula to Calculate Attendance Percentage in Excel

  • Use the Fill Handle tool and drag it down from cell E5 to cell E11 to copy the formula across the range.

Step 3 – Showing Final Result

  • All the students’ attendance percentages are returned:

Showing Final Result to Calculate Attendance Percentage in Excel

Download Practice Workbook

<< Go Back to Attendance | Formula List | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Bishawajit Chakraborty
Bishawajit Chakraborty

Bishawajit Chakraborty, a Rajshahi University of Engineering & Technology graduate with a B.Sc. in Mechanical Engineering, has been associated with ExcelDemy since 2022. Presently, he is a content developer, specializing in Excel Power Query, Data Analysis and VBA. It is worth mentioning that he has authored more than 90 articles on VBA content development. His profound interest lies in the fields of data analytics and data science. He possesses expertise in VBA, Power BI, machine learning, and Python... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF