Counting text in a range

To find out how many cells contain a text string in a range you can use the COUNTIF function and an Excel wildcard character.

To see how many cells contain abc in column A you could use


This will count abc no matter where it appears in the text eg 123abc, abc123 and 123abc123 will all be counted. It is only counted once per cell.

The * is the wildcard character.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.