Forum Discussion

Rockiesfan's avatar
Rockiesfan
Copper Contributor
Jan 25, 2024

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).  ...
Excel
Rockiesfan's avatar
Rockiesfan
Copper Contributor

HansVogelaar 

IA, IAV = in attendance

EXC, UEX, MEDEX = absent

Column E is the homeroom teacher.

 

  • Rockiesfan's avatar
    Rockiesfan
    Copper Contributor
    Jan 25, 2024
    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.
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Jan 25, 2024

      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.

      • Rockiesfan's avatar
        Rockiesfan
        Copper Contributor
        Jan 25, 2024
        Perfect! Thank you so much. Now if I can only repeat your steps for the next quarter. 🙂