To count true in google sheets you can use the COUNTIF formula.
Here is how to count true in google sheets:
1. In an empty cell type =COUNTIF(
2. Select the range of cells where you want to count
3. Add a comma and then type TRUE
4. Add closing parentheses and press enter
5. This will output the number of cells with a value of “TRUE”
The formula to count true in google sheets will look like this:
=COUNTIF(A1:A10, TRUE)
Here A1:A10 is the range where you are counting the number of TRUE entries.
Here is an animation showing this in action:
Note: Here you are counting TRUE entries in cells considering them as boolean fields. The above formula will also work for checkboxes with tick marks in the cell.
Table of content
Example of Count true in google sheets
Below, we have a list of cells in column A with true and false data in it. We want to count the number of TRUE and FALSE entries in column A.
Here is the data:
To count TRUE in google sheets, use the COUNTIF formula like below:
As you can see from above, the result outputs the count as 5. This means there are 5 TRUE entries found in column A.
To count FALSE in google sheets, use the COUNTIF formula like this:
=COUNTIF(A1:A10, FALSE)
As you can see, the formula found 5 entries of FALSE value in column A.
The COUNTIF formula only counts cells with a single criterion as input. If you want multiple criteria, use the COUNTIFS formula.
Count true in google sheets having checkboxes
Using the same COUNTIF formula you can count the number of checkboxes with tick marks in google sheets.
Below we have a list of data in column A with some of the cells that have checkboxes in them. We need to count the total number of TRUE entries in column A.
Use the formula =COUNTIF(A1:A10, TRUE)
As you see here, the formula has counted 6 true entries which include 3 cells with a value of TRUE and 3 cells with checkboxes with tick marks.
Count true in google sheets having text field (non-Boolean)
If the TRUE or FALSE value in the cell in google sheets is not a boolean but a text field, then you can first convert them to a boolean value and then use the COUNTIF formula to count the number of fields with true entries:
Let’s say, we have a list of true/false values like this: (Note that all are text fields)
Now select all the cells and click on Format > Number and then choose Automatic. This will convert the text to a boolean value.
Here is a demo showing the same:
This will convert all text fields to boolean fields.
Now that all fields are boolean, you can use the COUNTIF() formula to count the TRUE and FALSE values.
Count true and false in google sheets and output 1 or 0
To count true in google sheets and output 1 for TRUE and 0 for false, we can use the combination of COUNTIF and ARRAY FORMULA.
Below in column A, we have a mix of TRUE, FALSE, and checkboxes. We want to output 1 for TRUE values and 0 for FALSE.
The formula for this is:
=ARRAYFORMULA(--(A1:A17))
Count 0 or 1 in google sheets
To count 0 or 1 in google sheets, we can use the below formulas:
=COUNTIF(A1:A10, 1) =COUNTIF(A1:A10, 0)
FAQ
How do I count yes and no in Google Sheets?
To count yes or no in google sheets, use the COUNTIF formula. Here is the formula for counting yes or no in column E:
=COUNTIF(E1:E20,”yes”)
Since yes or no are not boolean values, you need to treat them as strings or text values while writing the COUNTIF formula.
How do you count the number of true cells?
Use the COUNTIF formula to count the number of true cells if the cells are of boolean format. Use =COUNTIF(range, TRUE) to count the number of true cells.
How do you use COUNTIF formula?
The syntax for Countif formula is =COUNTIF(range_where_to_count, criteria)
How do I count cells with text in Google Sheets?
You can use the COUNTIF formula to count specific text in a given range of cells. To search and count multiple texts, you can use the COUNTIFS formula.
Wrapping up
In this tutorial, you learned how to count true in google sheets. Also, you saw how to count false, checkboxes with tick marks, and non-boolean text fields of true/false values.
Go ahead and start using this in your worksheet. Let me know in the comments if you face any issues.
Appendix
[1] COUNTIF formula in google sheets – Link
Further Reading
New to google sheets ? Start here
More related to Logical functions:
Logical functions in google sheets
Learn more about Google sheets Formulas.
Error handling in google sheets
