# How To Count Checkboxes In Google Sheets

In this tutorial, you will learn how to count checkboxes in Google Sheets.

## How To Count Checkboxes In Google Sheets

If you use checkboxes in Google Sheets, it’s likely you’ve come across a situation where you wanted to get an accurate count of how many checkboxes in your spreadsheet have been checked off.

For example, if you’re using checkboxes to mark off completed tasks, counting how many checkboxes have been marked complete can help you track the status of your project.

Manually counting check marks every time you want to get the count would be time consuming and error-prone, but fortunately it’s easy to automatically count checkboxes with a simple formula

## Inserting Checkboxes

#### Step 1

Select the range you want to insert checkboxes into

#### Step 2

Open the Insert menu and click on the Checkboxes option

#### Step 3

A checkbox will be inserted into each cell in the selected range

#### Step 4

Go ahead and click on some of the checkboxes to mark them complete so you can count them.

Each time you click on a checkbox it will toggle between checked and unchecked

## Counting Checkboxes

Before we can construct a formula to count checkboxes, it’s important to understand how checkboxes work behind the scenes in Google Sheets.

Checkboxes look very different from other data that can be stored in cells, but behind the scenes they’re actually just fancy ways to display TRUE and FALSE values.

So when a checkbox is checked, the value TRUE is stored in that cell, and when it’s unchecked, the value FALSE is.

We can use this in our formula to count the number of checked boxes in a range

#### Step 1

Click on the cell you want to display the checkbox count in and type the following formula:

`=COUNTIF(B:B, TRUE)`

The COUNTIF formula counts all cells in a given range that meet certain criteria.

In this case, the formula is looking in the range B:B for all cells that have the value TRUE, or all checked boxes

#### Step 2

Hit enter to finish the formula and the total will appear in the cell

#### Step 3

You can confirm that it’s correct by toggling checkboxes on and off and watching the total update

#### Step 4

If you want to count unchecked boxes instead of checked boxes, use the same formula, but replace TRUE with FALSE: `=COUNTIF(B:B, FALSE)`