Count Greater Than 0 (COUNTIF)

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.

Table

Description automatically generated

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

Description automatically generated
  • Next, in the range argument specify the range (A2:A19) from which you want to count the numbers.
Application, table, Excel

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

Description automatically generated

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

Graphical user interface, application, table, Excel

Description automatically generated

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″)

Graphical user interface, application, table, Excel

Description automatically generated

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