Forum Discussion
Analyze Student Attendance Data
I have a very large spreadsheet with over 15K rows. The spreadsheet is an export from our student information system of student attendance data for the second reporting term (10/11/23 - 12/21/23). ...
Thanks! Does this do what you want?
Unfortunately, it does not. Looking at student 11071, they were in attendance for 34 out of 42 days. Their attendance would be 81%.
Each homeroom attendance should calculate a unique value based on the student attendance. Column L in your example is the value I'm looking for.
Each homeroom attendance should calculate a unique value based on the student attendance. Column L in your example is the value I'm looking for.
Rockiesfan My apologies, stupid mistake on my side.
The formula in I2 should be
=COUNTIFS($A$2:$A$15078,H2,$C$2:$C$15078,"IA*")/COUNTIFS($A$2:$A$15078,H2)
Fill down from there.
- Perfect! Thank you so much. Now if I can only repeat your steps for the next quarter. 🙂