Skip to content

Track Attendance in Google Sheets

This article will teach you how to set up a Google Sheets spreadsheet to track attendance!

Of course, there are many different ways that you can do this, but this method is easy to set up and use.

Build the Layout

To set up your spreadsheet, start by listing the names of each person in one column.

Next, list the days in a row (across columns) above and to the right of the names.

Finally, add a heading to indicate where you will count the attendance.

Add Checkboxes

With everything laid out, select the cells to the right of the names and below the days.

Next, in the Google Sheets menus, go to Insert Checkbox.

Your setup should now look like this.

Add the COUNTIF Function

Select the cell below the attendance heading.

Then, use the COUNTIF function to count the cells that contain TRUE in the same row.

=COUNTIF(C3:G3, TRUE)

Finally, use the Fill Handle to drag the formula down for each person.

Now you can use the checkboxes to mark the attendance for each person on your list.

Watch a Video

To see this in action, check out the video below!

This Post Has One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top