Thank you for your reply. Your formula is counting the names but it's not
ignoring duplicate names. Any other suggestions?

"T. Valko" wrote:

That probably means there are empty cells within the range.

Try this (normally entered, not an array):

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

Biff

"Bruce" wrote in message
...
This isn't working. When I enter the formula I get a "DIV/0" error.


"Gary''s Student" wrote:

=SUM(1/COUNTIF(A1:A10,A1:A10))
and confirm as an array formula (use CNTRL-SHFT-ENTER rather than just
ENTER)

will display 3 for your example.


--
Gary''s Student
gsnu200710


"Bruce" wrote:

Is there a way to count names in a column but have the formula ignore
duplicates?

example:

Column A
John Smith
John Smith
Jane Doe
Joe Smith

the formula would give me a total of - 3

I appreciate any and all help. Thank you in advance.