Last Updated on November 3, 2023 by Jake Sheridan
In this tutorial, you will learn how to count checkboxes in Google Sheets.
How To Count Checkboxes In Google Sheets
If you use checkboxes in Google Sheets, it’s likely you’ve come across a situation where you wanted to get an accurate count of how many checkboxes in your spreadsheet have been checked off.
For example, if you’re using checkboxes to mark off completed tasks, counting how many checkboxes have been marked complete can help you track the status of your project.
Manually counting check marks every time you want to get the count would be time consuming and error-prone, but fortunately it’s easy to automatically count checkboxes with a simple formula
If you don’t already have checkboxes in your Google Sheet, you’ll need to add them. Here’s how:
Select the range you want to insert checkboxes into
Open the Insert menu and click on the Checkboxes option
A checkbox will be inserted into each cell in the selected range
Go ahead and click on some of the checkboxes to mark them complete so you can count them.
Each time you click on a checkbox it will toggle between checked and unchecked
Before we can construct a formula to count checkboxes, it’s important to understand how checkboxes work behind the scenes in Google Sheets.
Checkboxes look very different from other data that can be stored in cells, but behind the scenes they’re actually just fancy ways to display TRUE and FALSE values.
So when a checkbox is checked, the value TRUE is stored in that cell, and when it’s unchecked, the value FALSE is.
We can use this in our formula to count the number of checked boxes in a range
Click on the cell you want to display the checkbox count in and type the following formula:
The COUNTIF formula counts all cells in a given range that meet certain criteria.
In this case, the formula is looking in the range B:B for all cells that have the value TRUE, or all checked boxes
Hit enter to finish the formula and the total will appear in the cell
You can confirm that it’s correct by toggling checkboxes on and off and watching the total update
If you want to count unchecked boxes instead of checked boxes, use the same formula, but replace TRUE with FALSE:
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to count checkboxes in Google Sheets. Want more? Check out all the Google Sheets Tutorials.