In this Excel tutorial you will teach yourself how to count occurences of a character in a spreadsheet.
How to count occurrences of character in a string?
Let’s count how many of f character do you have in a A coulmn.
To do that just use below formula:
This is an array formula so remember to press CTRL + SHIFT + ENTER combination.
Counting occurrences of a character in a spreadsheet may be useful for spreadsheets with unique text.
Also you may be interested in counting character which is related to your company/project and used as a your internal code.
How to count cells with a specific content in a range?
In this example you will see 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: