Formula for a count of names?

Alesha · Feb 22, 2005

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 · Feb 22, 2005

Have a look in HELP index for COUNTA

Gord Dibben · Feb 23, 2005

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