software

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.

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

=SUMPRODUCT((A1:A99lt;gt;quot;quot;)/COUNTIF(A1:A99,A1:A99amp;quot;quot;))

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

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

--

Dave Peterson