From A1 to A1000 my list has names that I add and erase depending on
something else. It is possible to keep update counting of how many names I
have in that mention range ? Which formula ?
THANKS

=COUNTA(A1:A1000) will count all names in that range.

Or do you mean unique names within the range?

See Chip Pearson's site for Counting Distinct Entries In A Range

http://www.cpearson.com/excel/Duplicates.aspx

Scroll down about 75% of page.


Gord Dibben MS Excel MVP

On Sat, 23 Aug 2008 16:28:01 -0700, computexcel
wrote:

From A1 to A1000 my list has names that I add and erase depending on
something else. It is possible to keep update counting of how many names I
have in that mention range ? Which formula ?
THANKS

No, I meant all names.
Yes, this is the formula I needed.
Thanks for the answer and for the website.

"Gord Dibben" wrote:

=COUNTA(A1:A1000) will count all names in that range.

Or do you mean unique names within the range?

See Chip Pearson's site for Counting Distinct Entries In A Range

http://www.cpearson.com/excel/Duplicates.aspx

Scroll down about 75% of page.


Gord Dibben MS Excel MVP

On Sat, 23 Aug 2008 16:28:01 -0700, computexcel
wrote:

From A1 to A1000 my list has names that I add and erase depending on
something else. It is possible to keep update counting of how many names I
have in that mention range ? Which formula ?
THANKS