If you want to count the checkboxes in Google Sheets, this guide will help you go through the process. You can count all the checkboxes conditionally with the help of the in-built function. However, this feature is limited to Google Sheets only.
Let’s assume that you have created a spreadsheet for your daily tasks, where you enter every single thing you need to do. If you want to track how many tasks you have completed at the end of the day, it is quite important to use a checkbox. You can simply tick a box when a task is done. In the end, you can use this guide to count how many checkboxes are ticked and how many are unchecked. It is pretty straightforward since you need to use the COUNTIF function.
How to count checkboxes in Google Sheets
To count checkbox in Google Sheets, follow these steps:
- Open the spreadsheet in Google Sheets.
- Select a cell where you want to display the checked boxes number.
- Enter this formula: COUNTIF(cell_range, criteria)
To learn more about these steps, continue reading.
To get started, you need to open the desired spreadsheet in Google Sheets. This sheet must have the checked and unchecked boxes. If so, select a cell where you want to display the number of checked or unchecked boxes and enter this formula:
COUNTIF(cell_range, criteria)
Let’s say you have all the checkboxes in the B column, and you want to display the number of checked boxes. If so, you need to enter this formula:
=COUNTIF(B1:B30, "TRUE")
Don’t forget to replace the cell range with the desired range of your spreadsheet. On the other hand, if you want to display the number of unchecked boxes, you need to enter this formula:
=COUNTIF(B1:B30, "FALSE")
Like the checked boxes formula, you need to replace the cell range in this formula as well.
For your information, you can use custom criteria and cell values. In other words, you can use any other criteria instead of TRUE or FALSE. For that, you need to use the Date validation panel.
To do that, select a cell, right-click on it, and select View more cell actions > Data validation. Next, you need to choose the Cell range and check the Checkbox from the Criteria drop-down list.
Next, tick the Use custom cell values and enter custom criteria for Checked and Unchecked boxes.
Once done, click the Save button. Then, you can enter the same formula as above. However, in this case, you need to use the custom criteria instead of the typical TRUE and FALSE.
That being said, the formula will look like this:
To display the number of checked boxes:
=COUNTIF(B1:B30, "TWC")
To display the number of unchecked boxes:
=COUNTIF(B1:B30, "TWC1")
Here TWC and TWC1 are the custom criteria for checked and unchecked boxes. If you have used the same, you can use the aforementioned formula. However, if you have used something else, you need to enter that instead of TWC and TWC1.
Read: How to change Date Format in Google Sheets and Excel Online
How to count number of checked checkbox in Google Sheets?
You can count the number of checked checkbox in Google Sheets using the guide mentioned above. It is possible to count almost anything in Excel and Google Sheets with the help of the COUNTIF function. You can use the same function to count the number of checked and unchecked checkboxes in Google Sheets.
How to count up checkboxes in Google Sheets?
To count checkboxes in Google Sheets using the COUNTIF function. Whether you want to count the checked or unchecked checkboxes, you can do both with the help of this guide. However, it is not possible to use the same function in other spreadsheet management apps, such as Excel, since Excel doesn’t allow users to insert checkboxes as Google Sheets does.
