If you wish to count the same or duplicate values in a column only once in Excel or the count of occurances of duplicate values, read this article.

Duplicate Remover for Excel goes through massive worksheets withtables up to 1 monster 1 million rows, and then finds and killsduplicate entries.