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:

=COUNTIF(A1:A10, "TRUE")

4. Press Enter to get the result.

Example

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:

=COUNTIF(B1:B5, "TRUE")

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