Blog

अटेंडेंस शीट (Attendance Sheet)

Step-by-Step:

1. Left में Students के नाम।
2. ऊपर Row में Dates: mathematicaCopyEditName | 1-July | 2-July | 3-July | ... | Total Present
3. “P”, “A” डालें।
4. COUNTIF:
   =COUNTIF(B2:AF2,"P")
5. Conditional Format:
   • Green = P
   • Red = A

Youtube channel:-https://www.youtube.com/channel/UCev6X7s2eQULqz5ILAUx-BQ

Instagram id:-https://www.instagram.com/erbadshahraushan?igsh=Y3ZyYWY4YTZ5ZXU=