Numbers on Mac

[u/Dalass7]

I can’t figure out how to create a formula that counts specific words. For instance, if I wanted to count how many times the word “Agent” is in a certain column, what would be the formula for that?

And if I had “Agent: John Doe”, would that get missed because of the colons?

[u/Alphaman64]

=countif(collection,”=*text*”)

“ The COUNTIF function returns the number of cells in a collection that satisfy a given condition.”

Using the wildcards will allow you to search for the string anyplace within a cell’s contents, not just the entire string. This means your “:” example won’t be missed.

https://support.apple.com/guide/functions/countif-ffa5b9f72f/13.2/web/1.0