We will use COUNTIF formula with logical operator of "=" that will make sure that only zero are counted.
How to COUNTIF() values greater then zero.
Countif criteria example with condition greater then zero
How to countif less then a value.
Counts the number of cells within a range that meet the given criteria
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM