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

=COUNTIF(A:A,"*abc*")

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.

Related Posts

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.