How To Count Cells With A Specific Content In A Range in Excel

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.  You can build formula like this:


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?


You can download the Template here – Download
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell