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 negative 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 are below zero in Celsius?
= COUNTIF(B2:B12, "<0")
The result returns 6, so six cities' temperatures are negative.
Formula 2: How many cities' temperatures are below zero in Fahrenheit?
= COUNTIF(C2:C12, "<0")
The result returns 0, so no city's temperature is negative in Fahrenheit.
Notes: The COUNTIF function
= COUNTIF(Range, "<0")
– The range is required, the cells you want to count.