 # How to Count Checkboxes in Google Sheets (The Easy Way!)

4 Minutes How flexible can the COUNTIF function be? We have seen a lot of examples from our previous tutorials. In this step-by-step tutorial we show you how to use it to count checkboxes.

## Count Checkboxes in Google Sheets

It's easy to count checkboxes in google sheets using the COUNTIF function. Check the syntax and the step-by-step example below to see it in action.

### Syntax

=COUNTIF(range,TRUE)

Where

range is where they are located

It’s that simple! See why through our example below.

### Example

Select the range, then click Insert in the main toolbar, then choose CheckboxCheck our complete tutorial for adding a checkbox here.

#### Step 2: Tick the cells

Ticking one sets the value of the cell to TRUE while leaving it unticked sets its value to FALSE. This value can easily be accessed by formulas in other cells.

#### Step 3: Add the formula =COUNTIF(range,TRUE)

Add the formula to another cell, setting the range. For our example it is stored in C2:C10 so we use the formula =COUNTIF(C2:C10, TRUE). Once you hit enter you will see the number of ticked checkboxes in your range.

## FAQs

### Can I Count Unticked or Empty Checkbox in Google Sheets?

Yes! Sometimes you need to tally empty boxes instead of the ticked ones. The solution is simple. The syntax for the formula is:

=COUNTIF(range,FALSE)

Where

range is where the boxes are located

Empty boxes have a FALSE value that can likewise be accessed by formulas you add.

Using the same example as above, we add the formula, setting the range to C2:C10 and the value to FALSE:

### Can I set Customized Values to Checkboxes?

Yes! It is possible to set customized values instead of the default TRUE for ticked and FALSE (0) for unticked boxes. For example, maybe you want true to be “closed” and false to be “open”.

#### Syntax

Ticked cells

=COUNTIF(range,value_if_true)

Where

range is where the boxes are located

value_if_true is the value you set if it is ticked

Unticked cells

=COUNTIF(range,value_if_false)

Where

range is where the boxes are located

value_if_false is the value you set if it is not ticked or unticked

#### Assign Custom Values to Checkboxes:

Step 2: Highlight your range and then click Data -> Data validation.

Step 3: Choose Checkbox under criteria and tick the Use custom cell values.

Step 4: Set the values for checked and unchecked. Click Save.

Step 5: Tick the cells

Step 6: Add the formula using the syntax =COUNTIF(range,value_if_true)

Follow the syntax, setting the range and the value depending on what you need to look for.    