Site icon ExcelNotes

How to Count Cells that are Positive Numbers

The COUNTIF function counts the number of cells that meet one criterion, such as the cells with a text string, the cells with a certain value, etc. The following formula is to help you get the count of cells that are positive numbers.

Example: You are working with a dataset with cities in column A, temperature (C) in column B, and temperature (F) in column C.

Formula 1: How many cities' temperatures (Celsius) are above zero?

= COUNTIF(B2:B12, ">0")

The result returns 5, so five cities' temperatures are positive in Celsius.

Formula 2: How many cities' temperatures (Fahrenheit) are above zero?

= COUNTIF(C2:C12, ">0")

The result returns 9, so nine cities' temperatures are positive in Fahrenheit.

Notes: The COUNTIF function

Formula:

= COUNTIF(Range, ">0")

Explanations:

– The range is required, the cells you want to count.

Exit mobile version