Count celsl equal too is part of COUNIT formula. There is a lot of formulas under countif category. In count cells equal to formula we will learn how to count cells cantainig a specific number, in a given range.
Sometimes we have data in large numbers and need to count that how many numbers of same value are there or in another words we want to know that how many time a value, word or figure has been repeated. In this condition it is very useful formula and help us to count cells equal to.
- Start formula typing with equal “=”.
- Type “countif”
- Start Bracket “(“
- Select Range
- Type comma “,”
- Type the number, value, name (to be checked)
- Close Bracket “)”.
For examples :`
In above illustration the result is 4, it shows that in the selected range BANANA has written 4 times.
