top of page

How to Count Checkboxes in Google Sheets: A Step-by-Step Guide

Google Sheets is a great tool for individuals and professionals to manage tasks, set reminders and much much more.


One of the most interactive features of Google Sheets is the checkbox function.


In this guide, we'll go through how you can count checkboxes in Google Sheets, improving your productivity and data management.


What You Will Learn:

  • Fundamentals of Google Sheets checkboxes

  • Steps to count checked and unchecked boxes

  • Customizing checkbox values to tailor them to your needs

  • Frequently asked questions about Google Sheets checkboxes


Follow along on your own spreadsheet or duplicate our free spreadsheet example.


Learn how to count checkboxes in Google Sheets

How to Count Checkboxes in Google Sheets?


Counting Checked Boxes


Counting checked boxes in Google Sheets can be done by following these three simple steps.

  1. Choose the cell for the result (C11)

  2. Type =COUNTIF(range, TRUE) - range in our example C5:C9

  3. Press ‘Enter’. The number of checked boxes will now be displayed


Counting checked boxes in Google Sheet


Counting Unchecked Boxes


Similarly, counting unchecked boxes in Google Sheets is not a tricky task. You can follow these three simple steps:

  1. Choose the cell for the result - in our example C12

  2. Type =COUNTIF(range, FALSE) - range in our example C5:C9

  3. Press ‘Enter’. The number of unchecked boxes will now be visible



Adding Custom Values to Checkboxes

Customizing the Checkbox's Default Values in Google Sheets

Customizing the Checkbox's Default Values


Google Sheets allows you to assign custom values to checkboxes, replacing the default TRUE and FALSE states. This can be particularly useful if you prefer specific words, numbers, or labels to denote the checkbox's status.


For instance, in our scenario, we might opt to signify checked boxes with “Completed” and unchecked boxes with “Open”. This not only makes our sheet more intuitive but also allows us to employ these custom values when utilizing the COUNTIF formula.


Here's how you can assign these custom values in six steps:

  1. Select the relevant cells - in our example C5:C9

  2. Navigate to ‘Data’ and choose ‘Data validation’

  3. Choose the ‘Tick Box’ option

  4. Click on ‘Use custom cell values’

  5. Now, set your custom values for the checked and unchecked states. Using our example, enter “Completed” for checked and “Open” for unchecked

  6. Confirm and save your changes


Now you can customize your COUNTIF formula and refer to cell B11 and B12, respectively. This way you don’t need to write it within the formula itself.



Conclusion


Counting checkboxes in Google Sheets is quite simple and can improve your data management and task tracking.


This guide walked you through the essentials, from understanding the checkboxes' basic functionality to customizing them to suit your unique needs.


With these tools in hand, you're well-equipped to make the most of Google Sheets in your daily workflow.



FAQ

Can you add checkboxes to Google Sheets?

Yes. The checkbox is an interactive feature in Google Sheets, enabling users to mark off completed items and tasks, thus paving the way for visual tracking and management.

Is there a way to add custom validation messages to checkboxes?






Comments


bottom of page