Formula for a count of names?

[Guest]

Is their a formula for a count of names?? example:

Joe Smoe
Larry Lie
Susan Kett

and have a formula add up how many names their are??

 

[Don Guillett]

Have a look in HELP index for COUNTA

 

[Gord Dibben]

Alesha

See Chip Pearson's site for formula(s) to count unique items in a range.

http://www.cpearson.com/excel/duplicat.htm#CountingUnique


Gord Dibben Excel MVP