This tutorial will teach us to count check boxes (total, ticked, and unticked).
When you insert a checkbox in Google Sheets, it also enters a Boolean value in the cell on which it is inserted. When the checkbox is, then it’s true and false if not selected.
Below is the example where we have ten checkboxes in column A.
And you can see a value in the cell where the checkbox is inserted.
Count All the Check Boxes
For this, you need to use the COUNTA function, enter the function and refer to the range of cells where you have checkboxes.
It will tell you the total number of checkboxes irrespective of the check and unchecked.
=COUNTA(A1:A10)Count Checked Checkboxes
For this, you need to use the COUNTIF function. In the function, refer to the range with checkboxes and in the criteria, enter TRUE.
In the above example, you have 3 checkboxes that are checked and the count we have got in the result.
=COUNTIF(A1:A10,TRUE)Count Un-Checked Checkboxes
And in the same way, if you want to count the unchecked checkboxes, you need to change the formula slightly.
You need to use the FALSE in the criteria argument instead of the TRUE. And when you hit enter returns with the 7 in the result, the count of unchecked checkboxes.
=COUNTIF(A1:A10,FALSE)