Google Sheets, being the versatile tool that it is, comes with a host of functionalities. One such functionality is the ability to insert checkboxes into cells. These checkboxes are well suited for tasks like creating to-do lists or marking an item as done in a project management spreadsheet. However, what if you need to count the number of checkboxes that have been checked or unchecked? Today we are going to learn how to do just that!
Counting Checked and Unchecked Checkboxes
Google Sheets allows you to count the number of checked and unchecked checkboxes using simple count formulas. Let’s dive into the step-by-step process:
First, let’s insert checkboxes into our cells. For this, you need to select the cells where you want to insert the checkboxes. Then, navigate to Insert > Checkbox.
Counting Checked Checkboxes
Now let’s count the number of checked checkboxes. We are going to use the COUNTIF function for this purpose. The COUNTIF function in Google Sheets is used to count the number of cells that meet a certain condition.
The formula to count the number of checked checkboxes is as follows:
Here, range is the range of cells that contain the checkboxes. The function will then count the number of checkboxes that are checked (since checked checkboxes are represented as TRUE).
Counting Unchecked Checkboxes
Similarly, to count the number of unchecked checkboxes, we use the COUNTIF function again. The difference this time is that we are searching for FALSE values since unchecked checkboxes are represented as FALSE. The formula is as follows:
And there you have it, an easy way to count the number of checked or unchecked checkboxes in Google Sheets. With these simple formulas, you can now track the progress of your tasks, projects, or any other list where you are using checkboxes. Happy spreadsheeting!
Published on January 19, 2023