Use a pivot table, add a header. select the range header and all and do
datapivottable and pivotchart report, click next twice, click layout,
drag the header into the row and the data areas, click OK, click finish

done


--

Regards,

Peo Sjoblom


"DTTODGG" wrote in message
...
Thank-you will, but, this would take 50+ IFs?
Is there a way to look for all the names and then count them?
Thanks

"will A" wrote:

=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!