Exceljet

Quick, clean, and to the point

Count cells that contain positive numbers

Excel formula: Count cells that contain positive numbers
Generic formula 
=COUNTIF(rng,">0")
Summary 

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, the active cell contains this formula:

=COUNTIF(B5:B10,">0")
Explanation 

COUNTIF 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". The total count of all cells in the range that meet this criteria is returned by the function.

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")
Author 
Dave Bruns
Related formulas 
Excel formula: Count cells between two numbers
Count cells between two numbers
The COUNTIFS function is built to count cells that meet multiple criteria. In this case, because we supply the same range for two criteria, each cell in the range must meet both criteria in order to be counted. Using COUNTIF instead If you have an...
Excel formula: Count cells greater than
Count cells greater than
COUNTIF counts the number of cells in the range that contain numeric values greater than X, and returns the result as a number. If you want to count cells that are greater than or equal to 90, use: = COUNTIF ( C5:C11 , ">=90" ) If you...
Excel formula: Count cells that contain negative numbers
Count cells that contain negative numbers
COUNTIF counts the number of cells in a range that match the supplied criteria. In this case, the criteria is supplied as "
Related functions 
Excel COUNTIF function
Excel COUNTIF Function

COUNTIF is an Excel function to count cells in a range that meet a single condition. COUNTIF can be used to count cells that contain dates, numbers, and text. The criteria used in COUNTIF supports logical...

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

500 Formulas | 101 Functions

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.