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