The **COUNTIF function** is to count the number of cells that meet one criterion such as the cells with a text string, and 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:** To count how many cities' temperature (Celsius) is above zero

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

The result returns 5, there are five cities where the temperature in celsius is positive.

**Formula 2:** To count how many cities' temperature (Fahrenheit) is above zero

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

The result returns 9, there are nine cities where the temperature in Fahrenheit is positive.

**Notes: The COUNTIF function**

**Formula:**

= COUNTIF(Range, ">0")

**Explanations:**

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