Count multiple occurances in a column
=countif(a1:a2000,"sally")
"DTTODGG" wrote:
Hello-
I read thru many posts, but none have the same question - I don't think.
I have a column with names in it, maybe 50 unique names, but the column is
2000 cells long. I would like to know how many times each of the names is in
the column.
Sally = 25
Tom = 333
Bob = 2
etc.
Thank you so much!
|