Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to calculate employee attendance percentage in Excel and Google Sheets
Topic:PercentagesExcel & Google Sheets
=COUNTIF(B2:B5,"Present")/COUNTA(B2:B5)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Employee Name | Attendance |
| Alice | Present |
| Bob | Absent |
| Charlie | Present |
| David | Present |
=COUNTIF(B2:B5,"Present")/COUNTA(B2:B5)→0.75
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Enter your employee names in column A and their attendance status (e.g., Present, Absent) in column B.
- 2Select the cell where you want the attendance percentage to appear.
- 3Enter the formula provided for either Excel or Google Sheets.
- 4Press Enter to calculate the percentage.
Tips
- Ensure all attendance statuses are consistently capitalized (e.g., "Present", "Absent").
- If using different languages, adjust the text in the formula accordingly (e.g., "Présent" in French).
- Check for any blank cells in your data range as they can affect the COUNTA function.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
What if my attendance data includes holidays or weekends?
Exclude those days from your COUNTA range or use a more complex formula to account for them.
Can I use this method for multiple employees?
Yes, by expanding the formula to include additional columns or rows as needed.
How do I format the result as a percentage?
Right-click the cell, select Format Cells, and choose Percentage in Excel or Format > Number > Percent in Google Sheets.
More on Percentages
See all →How-to
How to calculate a percentage
Work out what percentage one number is of another with a simple division, then format the result as a percent. Same in Excel and Google Sheets.
Error fixFix Wrong %
Fix wrong percentage results in Excel and Google Sheets — caused by conflating the percentage symbol with the decimal value or double-applying the % format.
How-toHow to calculate percentage change
Find the percentage increase or decrease between two numbers with (new − old) / old, then format as a percent. Works in Excel and Sheets.
How-toHow to add a percentage to a number
Increase a number by a percentage with number × (1 + rate) — handy for tax, markup, or raises. Same in both apps.
How-toHow to calculate a cumulative percentage
Use a running SUM divided by the total SUM to build a cumulative percentage column in Excel or Google Sheets.
How-toHow to calculate attendance percentage
Divide attended sessions by total sessions and multiply by 100 to get attendance percentage in Excel or Google Sheets.