How to Take Attendance in Google Sheets
Learn how to efficiently take attendance in Google Sheets using checkboxes, formulas for counting, and calculating attendance percentages.
So you might be taking attendance like this, and this is totally a good way to take attendance . If you have all your students here on the left side and you have every day of the week here, or you're doing every single day, like you have the date here, totally fine. You're going to want to insert a checkbox here and you can do that for the entire column and also all of these columns as well. So we can just copy paste these checkboxes. And as we go through each day, you can check off everyone who's here or everyone who's not here. Or check off everyone with just a simple space bar and then check off the people who are not here. Maybe that's easier to actually say everyone's here except for, say, Carla. And as you're doing this, you can get a percentage or a count, no matter what you want. You can do a count, and let's insert another row here. Let's insert another column here and get a percentage of attendance. Everything I know about Checkboxes (Cool Hacks) How To Hide Data with Checkboxes in Google Sheets Advanced Attendance in Google Sheets
So our count equals count if, and we're going to select the entire row . Area that we want to count, have a comma. I'm going to add a comma, and then we're going to look for all the true, and here it'll count all the true. We can autofill . And a percentage, we want to know which percentage of these are true. So we get to, let's say, these are done, we want to know which ones are 100%, which ones aren't. So we're going to, you can reference this cell, but we can also use the exact formula here. But we can say equals, count if true. What we need to do is actually do COUNTIF TRUE divided by COUNTIF TRUE plus the sum of COUNTIF TRUE and COUNTIF FALSE. So put FALSE here. Make sure we only have one equal sign. And we're going to get a one here, but this is a percentage, so we Ken Asks: How can I count true and false? Answer: w/ CountIF() How can I count true and false? IF All Above Are Filled Conditional Formatting
need to select FORMAT AS PERCENT. And then we can copy and paste this all the way down. We can copy and paste this all the way down. We can also format it, Decrease the decimal places here, and we get now a clear 100 percent or 80 percent attendance. EZ Grader™ Built by BetterSheets.co EZ Grader in Google Sheets