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 shown, cell F5 contains this formula:

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

Explanation

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

Author

Dave Bruns

Related formulas

Count cells between two numbers

In this example, the goal is to count numbers that fall within specific ranges. The lower value comes from the "Start" column, and the upper value comes from the "End" column. For each range, we want to include the both the lower value and the upper...

Count cells greater than

In this example the goal is to count test scores in column C that are greater than 90. The simplest way to do this is with the COUNTIF function , which takes two arguments , range and criteria : = COUNTIF ( range , criteria ) All test scores are in...

Count cells that contain negative numbers

In this example, the goal is to count the number of cells in a range that contain negative numbers. For convenience, the range B5:B15 is named data . This problem can be solved with the the COUNTIF function or the SUMPRODUCT function. Both methods...

Related functions

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

Related courses

Core Formula

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

Exceljet

Quick, clean, and to the point

Count cells that contain positive numbers

Positive including zero

Other criteria

Excel Formula Training

Download 100+ Important Excel Functions

Excel video training