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 you just need to use sumproduct function


The formula

You can build formula like this:


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



Other examples

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


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