How to COUNT IF True in Google Sheets

You can use the following formula in Google Sheets to count the number of TRUE values in a given column:

=COUNTIF(A2:A11, TRUE)

This particular formula counts the number of cells in A2:A11 that contain the value TRUE in the cell.

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

Example: COUNT IF True in Google Sheets

Suppose we have the following column of TRUE and FALSE values in Google Sheets:

We can use the following formula to count the number of TRUE values in the column:

=COUNTIF(A2:A11, TRUE)

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

From the output we can see that there are 6 total TRUE values in the column.

We can manually verify this is correct by counting the TRUE values in the column:

There are indeed 6 total TRUE values.

Note: To count the number of FALSE values in the column instead, simply replace TRUE with FALSE in the formula.

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