sort

B

Bobt

Have a column with hundreds of names. Sometimes the names appear more than
once. Would like to total the column by the number of names. Do not want a
name added to the total more than once. EX: John Smith appears 5 times in
the column. I only want it counted once.
Thanks.
 
D

Dave Peterson

This'll count the number of distinct values in a range:

=SUMPRODUCT((A1:A99<>"")/COUNTIF(A1:A99,A1:A99&""))

(adjust the range to match, but don't use the whole column)
 
Top