How To Have Google Sheets Count Checkboxes

Checkboxes are a great feature in Google Sheets. They can be used for a myriad of tasks such as to-do lists, attendance records, and much more. An especially useful functionality is the ability to count these checkboxes. This blog post will guide you through the steps on how to do this.

1. Inserting a Checkbox

The first step is to insert the checkboxes. Navigate to the cell where you want to add a checkbox and click on Insert > Checkbox. Repeat this step for as many checkboxes as you need.

2. Counting the Checkboxes

To count the checkboxes, we will use the COUNTIF function. This function counts the number of cells within a range that meet the given condition.

For our use case, the condition is TRUE (meaning that the checkbox is checked). Here’s how you can do it:

Let’s suppose we have checkboxes in cells A1 to A5. To count the checkboxes that are ticked (checked), we can use the following formula:


If you want to count the unchecked boxes, just replace TRUE with FALSE in the formula:


3. Applying the Formula

After you’ve written the formula, just hit the Enter key. The cell where you wrote the formula will then display the count of checked or unchecked checkboxes, depending on the condition you used.


And there you have it! Now you know how to make Google Sheets count checkboxes. This feature can be a powerful tool for productivity and data analysis, so make sure to take full advantage of it. Happy counting!