jayrrr
jayrrr

Reputation: 179

Google Sheets count occurance of words

I have a column in my spreadsheet that is a list of names and i want to count how often a name appears in that list.. i searched a lot and found out that I should usw "=COUNTIF(A:A,"John Doe"), but that gives me parsing errors ..

Basically, I have a list like this:

John Doe
Jane Doe
Jane Doe
John Doe
John Doe
John Doe
Jane Doe

And I need to count, how often the names appears in that list, so the result would be

John Doe | 4 
Jane Doe | 3

Upvotes: 0

Views: 3267

Answers (1)

jayrrr
jayrrr

Reputation: 179

I am so stupid :D

=COUNTIF(A:A; "John Doe") with a ";" works fine.. I always used "," to seperate..

Upvotes: 3

Related Questions