Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Count number of times text appears in column

I wish to count the number of times a piece of text appears in a column. I only want to display that number on a chart. I've tried the following:

FIND("Text", [Book Name])

"Text" is the text I am looking for, [Book Name] is the name of the column to search.

It does produce a good return but when I display it on a chart, it also shows the number of times it didn't appear. I only want to show the times it did appear. Is there a way to filter out the number of times it doesn't find the text so it doesn't appear. Thank you.

1 12 534
12 REPLIES 12
Top Labels in this Space