To count values that are greater than zero (0) from a list of values or a range of cells, you can simply use Excel’s COUNTIF function using greater than zero criteria. COUNTIF is part of the statistical functions.

Here we have list of numbers ranging from -10 to 10 and you need to count the numbers which are greater than zero from this list.

- First, type “=COUNTIF” and start parentheses in cell C1 where we are going to get the result.

- Next, in the range argument specify the range (A2:A19) from which you want to count the numbers.

- After that, type a comma to move to the next argument.
- In the end, enter “>0” in the criteria argument and closing parentheses.

When you hit enter, you will get the result in cell C1. And here this formula returns 11 in the result.

## COUNTIFS to Count Greater than Zero and Less than 10

And if you want to count number of which are greater than zero or less a 10 or any other number then you need to use the COUNTIFS function. Below is the formula that you can use:

=COUNTIFS(A2:A19,”>0″,A2:A19,”<10″)

In the above formula, as I said, you have the COUNTIFS function that allows you to refer to multiple ranges and specify multiple criteria.