Count number of text occurrences in column using Numbers I am using Numbers to track data. I have a column that has comma separated values within each row (e.g. ‘I like cats, I hate rain, I like dogs’).

Is it possible to count the number of appearances for a specific phrase (e.g. ‘I like cats’) and report that count in a cell, for each phrase?
COUNTIF(range,"=*string*")


Replace ‘range’ with the range of cells to count.
Replace ‘string’ with the string to match in the range.

For example, to count the number of occurrences of ‘I like cats’ in the A column, use COUNTIF(A,"=*I like cats*").