You can use the following basic formula to count the number of cells that have a value greater than zero in Excel:

**=COUNTIF(B2:B11, ">0")
**

This particular formula counts the number of cells in the range **B2:B11** that have a value greater than zero.

The following example shows how to use this formula in practice.

**Example: COUNTIF Greater Than Zero in Excel**

Suppose we have the following dataset in Excel that shows the number of sales made by various employees at a company during a given month:

We can use the following formula to count the number of employees who made more than zero sales:

**=COUNTIF(B2:B11, ">0")**

The following screenshot shows how to use this formula in practice:

We can see that **6** employees had more than zero sales.

We can confirm this by manually identifying each of these employees:

If you would like to count the number of cells in a range that are **equal to or greater than zero**, simply use the following formula:

**=COUNTIF(B2:B11, ">=0")**

**Additional Resources**

The following tutorials explain how to perform other common **COUNTIF()** operations in Excel:

Excel: COUNTIF Greater Than But Less Than Some Number

Excel: COUNTIF with Multiple Ranges

Excel: COUNTIF Less Than Date