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")
Explanation 

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(B2:B6,">0")

How this formula works

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

Excel Formula Training

Formulas are the key to getting work done in Excel. In this step-by-step 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. Start building valuable skills with Excel formulas today. Learn more.

I really appreciate your delivery of the videos, the clean and sharp documentation and pleasant to the eye website, uncluttered, direct, short and snappy. From what I've checked out elsewhere nothing compares... - Christina
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course