# How to count checkboxes in Google Sheets

In Google Sheets, **checkboxes** are a type of data validation that allows users to select or deselect a binary choice. They are represented by small square boxes that can be checked or unchecked by clicking on them. Checkboxes are commonly used in spreadsheets to track tasks, mark completion status, or create interactive forms.

The dataset provides basic information about employees, including their unique identifiers, names, ages, genders, the departments they belong to, and their attendance in the form of checkboxes. In today’s tutorial, we will learn how to count the ticked, unticked, and total number of checkboxes.

## Case 1 – Counting the ticked check-boxes

## Step 1 – Selecting the cell

- Firstly, select any cell in which you want to calculate the number of
**ticked checkboxes.** - In this cell, we will apply the
**COUNTIF Formula**to get the**total**number**of ticked checkboxes.**

## Step 2 – Writing the formula

- In the selected cell
**type “=”**(without quotes) and then write**COUNTIF**in the selected cell and select the**COUNTIF Function**by pressing the**tab button**on your keyboard. - Then,
**select the range of cells**in which the**checkboxes are present.**For example, we’ve selected the range of cells (**F2:F6**). - After doing that,
**press the comma (,)**button on your keyboard and then**write TRUE.** - Now, your formula would look like this,

**=****COUNTIF****(****F2****:****F6****,****TRUE)**

## Step 3 – Implementing the formula

- Then,
**close the parenthesis**and**press Enter.** - After that, the
**result would appear**on the screen which is**3,**and as you can see the**3 checkboxes are ticked**and the answer is according to it.

## Case 2 – Counting the unticked checkboxes

## Step 1 – Selecting the cell

- First of all, select any vacant cell in which you want to calculate the number of
**unticked checkboxes.** - In this cell, we will use the
**COUNTIF Formula**in this cell to get the**total**number of**unticked checkboxes.**

## Step 2 – Writing the formula

- Type
**“=” (without quotes)**in the selected cell,**followed by “COUNTIF”.** - Press the
**Tab button**on your keyboard to select the**COUNTIF Function.** **Select the range of cells**where the**checkboxes are located.**For example, if the checkboxes are in cells**F2 to F6**, select that range.- Press the
**comma (,)****button**on your keyboard. - Type
**“FALSE” (without quotes)**after the comma. - Your formula should now look like this:

**=****COUNTIF****(****F2****:****F6****, ****FALSE)**

## Step 3 – Implementing the formula

**Close the parenthesis**and**press Enter.**- The result will appear on the screen, indicating the
**number of unticked checkboxes.**For example, if the**result is 2**, it means that**2 checkboxes are unticked.**

## Case 3 – Counting the ticked and unticked checkboxes

## Step 1 – Selecting the cell

- First of all, select any vacant cell in which you want to calculate
**the total number of checkboxes.** - In this cell, we will use the
**SUM Function**to find the**total number of checkboxes.**

## Step 2 – Writing the formula

- Firstly, write
**= (equal sign)**in the selected cell. - Then, type
**SUM**and select the**SUM Function**by using the**tab button**on your keyboard**.** - After that,
**select or enter**the**name of the cell**in which the result of the**total ticked checkboxes**is present. For example, it is**cell G2**in our case. - Then, press the
**comma (,) button**and then**select or enter the name of the cell**in which the**result of total unticked checkboxes**is present. For example, it is**cell H2**in our case. - Now your formula would look like this,

**=SUM(G2,H2)**

## Step 3 – Implementing the formula

- After writing the formula,
**close the parenthesis**and**press Enter.** - The result would appear in the cell which is
**5**and as we can see the**total number of checkboxes is 5**which is**according to the answer.**