3

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?

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .