In this tutorial, you will learn how to count checkboxes in Google Sheets
How to Count Checkboxes in Google Sheets
Google Sheets checkboxes are a powerful data validation feature that can add a level of interactivity to your sheets. When working with checkboxes in Google Sheets, you may need to count the number of checkboxes that are checked or unchecked.
By default, a checkbox represents either a TRUE or FALSE value. We can use the COUNTIF formula to check how many checkboxes hold either of these two values.
In this guide, we will show you how to use the COUNTIF function to count the number of checkboxes in Google Sheets. We will also show how to handle checkboxes with custom values.
How to Find the Total Number of Checked Checkboxes in a Column in Google Sheets
Here’s how to find the total number of checked checkboxes in a column in Google Sheets.
Step 1
First, select an empty cell to place the count of checked or unchecked checkboxes.
In our example above, we have a mailing list with a field labeled “Received”. We want to count how many cells in the “Received” column are checked.
Step 2
Type the COUNTIF function and enter the range with the checkboxes as the first argument.
Step 3
If you want to count the number of checked checkboxes, set the second argument to TRUE.
This will return the total number of checked checkboxes in the given range.
Step 4
Google Sheets also allows users to use custom cell values for checked and unchecked checkboxes.
Instead of TRUE or FALSE, the checkboxes will hold the custom value.
Step 5
We can modify our COUNTIF function to handle custom values for checked and unchecked checkboxes.
We simply need to update the criteria indicated in the second argument of the COUNTIF function.
Summary
This guide should be everything you need to count the checkboxes in Google Sheets
You may make a copy of this example spreadsheet to test it out on your own.