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). ...
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. 🙂