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 zeros
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 zero
= COUNTIF(B2:B12, "=0")
The result returns 0, there is no city's temperature is zero degrees in celsius.
Formula 2: To count how many cities' temperature (Fahrenheit) is zero
= COUNTIF(C2:C12, "=0")
The result returns 2, there are two cities' temperature is zero degrees in Fahrenheit.
Notes: The COUNTIF function
= COUNTIF(Range, "=0")
– The range is required, the range of cells you want to count.