Count number of text occurrences in column using Numbers

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?

Best Answer

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*").