How to count cells with a specific content in a range?

In this lesson you will teach yourself how to count the number of cells with specific content in a range in clever way. You need only one formula to do this!

To count a number of cells with a text in a specific range just use this formula:


You can count a number of cells with a value as well with similar formula:



There are others functions you can use with this kind of formulas:


Isn't an Excel wonderful that makes your life so much easier?