How to Use COUNTIF Greater Than Zero in Google Sheets

To use COUNTIF with greater than zero in Google Sheets, you'll need to use the COUNTIF function with a specific criterion - ">0". This criterion will only count cells that have a value greater than zero. Follow these steps to apply this function in your Google Sheets.

1. Open your Google Sheet.
2. Click on a cell where you'd like to display the result of the COUNTIF function.
3. Type the following formula, replacing "A1:A10" with the range of cells you'd like to count:

=COUNTIF(A1:A10, ">0")

4. Press Enter to apply the formula. The result will display the count of cells with a value greater than zero.

Example

Let's say you have the following data in cells A1 to A7:

5
-3
0
8
-1
12
0

Now, you want to count how many cells have a value greater than zero. Follow these steps:

1. Click on a cell where you'd like the result, for example, B1.
2. Enter the formula:

=COUNTIF(A1:A7, ">0")

3. Press Enter to apply the formula.

The result in cell B1 will be "3", as there are three cells (A1, A4, and A6) with a value greater than zero.