How to COUNTIF True in Google Sheets

To COUNTIF True in Google Sheets, you'll need to use the COUNTIF function. COUNTIF is a function that counts the number of cells within a range that meet a specified condition. In this case, the condition is whether the cell contains "TRUE" or not.

Follow these steps to COUNTIF True in Google Sheets:

  1. Open your Google Sheets document or create a new one.
  2. Click on an empty cell where you want to display the count of TRUE values.
  3. Enter the COUNTIF formula: =COUNTIF(range, "TRUE")

Replace "range" with the range of cells you want to search for TRUE values. For example, if you want to search for TRUE values in cells A1:A10, your formula would look like this:


  1. Press Enter to get the result.


Let's say you have a list of tasks in Column A, and their completion status (TRUE or FALSE) in Column B.

Tasks          | Completed
Task 1         | TRUE
Task 2         | FALSE
Task 3         | TRUE
Task 4         | FALSE
Task 5         | TRUE

To count the number of completed tasks (where the value in Column B is TRUE), you'd enter the COUNTIF formula in an empty cell:


The result would be 3, since there are three TRUE values in the range B1:B5.

Did you find this useful?