Count number of text occurrences in column using Numbers
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*").