Count cells that contain positive numbers

=COUNTIF(rng,">0")
To count positive numbers in a range of cells, you can use the COUNTIF function. In the generic form of the formula (above) rng represents a range of cells that contain numbers. In the example shown, cell F5 contains this formula:
=COUNTIF(B5:B10,">0")
The COUNTIF function counts the number of cells in a range that match the supplied criteria. In this case, the criteria is supplied as ">0", which is evaluated as "values greater than zero". COUNTIF returns the count of all cells in the range that meet this criteria. COUNTIF is part of a group of Excel functions that split logical expressions into two parts. As a result, criteria that include logical operators is entered as text, surrounded by double quotes (").
Positive including zero
The formula above excludes cells that contain zero (0). To include zero values in the count, adjust the formula to use greater than or equal to (">=") zero. The formula in F6 is:
=COUNTIF(B5:B10,">=0")
Other criteria
You can easily adjust this formula to count cells based on other criteria. For example, to count all cells with a value greater than or equal to 100, use this formula:
=COUNTIF(rng,">=100")
See also: 50 examples of formula criteria.
Download 100+ Important Excel Functions
Get over 100 Excel Functions you should know in one handy PDF.