You can use the Attendance Report and the =COUNTIF excel formula to quickly generate a report of how many students attend your facility or classroom per day. This article will walk you through the 3 steps to extract this data.

Step 1: Download Detailed Report
Go to Attendance-->Monthly, select your month, click Go and use the XLS button to download the "Detailed Report"

Step 2: Count Students/Day
Scroll to the bottom of the data column and use the following formula to count the number of entries per day:
=COUNTIF(range,">0")
To select the range simply drag to highlight the entire date's column of data, it will end up looking something like this: =COUNTIF(Q3:Q23,">0")

Step 3: Tally for all Dates
Now you can highlight that cell and drag it along the bottom to calculate the students who attended each day of the month


Note: If the children are signed in and out of multiple rooms each day that will create duplicates, you will first need to go in and delete all duplicate child entries before running the formula

Did this answer your question?