# 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.

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

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

- 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:

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

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

- 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.

Did you find this useful?