Please enable JavaScript to view the comments powered by Disqus.


Counting cell with value equal to zero.

We will use COUNTIF formula with logical operator of "=" that will make sure that only zero are counted.

Used Functions

Category: Statistical

Counts the number of cells within a range that meet the given criteria


COUNTIF(range, criteria)

Lets chat on this