You can use the following formula to count the number of checkboxes that are checked in Google Sheets:

=COUNTIF(B2:B11, TRUE)

This particular formula counts the number of checkboxes that are checked in the range **B2:B11**.

The following example shows how to use this formula in practice.

**Example: How to Count Checkboxes in Google Sheets**

Suppose we have the following dataset in Google Sheets that shows whether or not various students met the deadline to apply for a particular university:

**Note**: You can add checkboxes to a range of cells by selecting a range, then clicking the **Insert** tab, then clicking **Checkbox**.

We can use the following formula to count the number of checkboxes that are checked in the range **B2:B11**:

=COUNTIF(B2:B11, TRUE)

The following screenshot shows how to use this formula in practice:

The formula returns **6**, which tells us that 6 total checkboxes are checked in the range **B2:B11**.

**Note**: Google Sheets stores checkbox values as either **TRUE** or **FALSE** to indicate if they are checked.

Thus, in this formula we simply count the number of values that are equal to **TRUE**, which is the same as counting the number of checkboxes that are checked.

If you’d like, you could also use the following formula to find the percentage of total checkboxes that are checked:

=COUNTIF(B2:B11, TRUE)/COUNTA(B2:B11)

The following screenshot shows how to use this formula in practice:

The formula returns **0.6**, which tells us that **60%** of all checkboxes in column B are checked.

**Note**: This formula works by counting the number of checkboxes checked and then dividing that number by the total number of checkboxes.

**Additional Resources**

The following tutorials explain how to perform other common operations in Google Sheets:

Google Sheets: Change Color when Checkbox is Checked

Google Sheets: Add Strikethrough When Checkbox is Checked

Google Sheets: How to Sum If Checkbox is Checked