Table of Contents
To count how many cells are greater than zero, use the COUNTIF function in Excel. This function takes two arguments, the range of cells to be evaluated and the criteria that must be met for a cell to be counted. For example, the formula =COUNTIF(A1:A10, “>0”) will count how many cells in the range A1 to A10 are greater than zero.
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")