# Use COUNTIF Function to Count Checkbox in Google Sheets

Checkboxes are interactive boxes that help us to keep track of a list for example a to-do list. We can count checked as well as unchecked items from a checklist in Google Sheets by using various methods. In this article, we are going to explore how to use the COUNTIF function to count checkbox in Google Sheets.

## A Sample of Practice Spreadsheet

Insertion of checkbox in Google Sheets is super easy. Just select a cell and then go to Insert >> Checkbox to add a checkbox in the selected cell.

## 2 Suitable Examples of Counting Checkboxes Using COUNTIF in Google Sheets

The COUNTIF function of Google Sheets can easily count checkboxes based on the given condition. Here we demonstrate how to count checked and unchecked items using the COUNTIF function with two ideal examples.

### 1. Counting Checked Items

A checkbox in Google Sheets takes two values. If a checkbox is ticked then its value is TRUE and FALSE otherwise. In this example, we count checkboxes that are ticked or checked using the COUNTIF function. Follow the steps below to learn this.

📌 Steps:

• Initially, we select cell C13 to count the checked item.
`=COUNTIF(C5:C12,TRUE)`
• Then we insert the above formula in the formula bar.

• Pressing enter gives us the total count of the checked item in the selected cell.

### 2. Counting Unchecked Items

In this example, we want to count checkboxes that are unchecked using the COUNTIF function. Go through the steps below to accomplish this.

📌 Steps:

• Firstly, we select cell C13 to count the unchecked item.
`=COUNTIF(C5:C12,FALSE)`
• Then we insert the above formula in the formula bar.

• After pressing enter we get the total count of Unfinished Work or unchecked items from the checkboxes as follows.

## Alternative of COUNTIF Function to Count Checkboxes in Google Sheets

There are many other alternative ways of counting checkboxes in Google Sheets. For example, the use of the COUNTIFS function, inserting pivot table, using the SUM function, and so on. Among them, the COUNTIFS function can easily replace the COUNTIF function and perform the above task.

📌 Steps:

• First of all, we select cell C13 to count the checked items.
`=COUNTIFS(C5:C12,TRUE)`
• Then we insert the above formula in the formula bar.

• As a result, we get the total count of checked items in the selected cell as we got when using the COUNTIF function.

## Things to Remember

• Try to use COUNTIFS, if there are multiple conditions to count checkboxes.
• Be careful about the data range of the COUNTIF function.

## Conclusion

In conclusion, I believe from now on you can easily count checkbox in Google Sheets using the COUNTIF function. Further, If you have any questions regarding this article feel free to comment below and I will try to reach out to you soon. Visit our website OfficeWheel for many more useful articles.

## Related Articles

#### Laku

Hey, I'm Zahidul Islam Laku. I completed my graduation from Bangladesh University of Science and Technology (BUET). I write articles about a variety of tech topics. I enjoy using my abilities as a creative thinker and problem-solver to develop original solutions to issues.

We will be happy to hear your thoughts