Complete guide with ready-to-use formulas, COUNTIF method, conditional formatting for 75% rule, and step-by-step instructions.
If you have total classes in column A and attended classes in column B:
This gives you the percentage as a number (e.g., 75). Format the cell as Number with 2 decimal places.
| Cell | A (Total) | B (Attended) | C (Formula) | Result |
|---|---|---|---|---|
| Row 2 | 80 | 60 | =B2/A2*100 | 75.00% |
| Row 3 | 100 | 85 | =B3/A3*100 | 85.00% |
| Row 4 | 90 | 62 | =B4/A4*100 | 68.89% |
Use this formula and format cell as percentage:
Add an IF formula to auto-flag attendance status:
If your sheet has daily attendance marked as "P" (Present) or "A" (Absent):
COUNTIF(B2:B100,"P") — counts all cells with "P" (Present)COUNTA(B2:B100) — counts all non-empty cells (total class days)*100 — converts to percentageAutomatically color cells red if below 75%:
=B2/A2*100=B2/A2 (format as %)=IF(B2/A2>=0.75,"Safe","Low")=COUNTIF(B:B,"P")/COUNTA(B:B)*100Skip Excel entirely — use our instant online calculator.