Counting names in a column

[Chuck]

I have entered a list of names in Column A. How can I count the number
of names I have entered and have that number appear in cell B1. I will
be entering a varying number of names each time I open and use this
worksheet. Thanks for the help.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Jan Eikeland]

hi, im quite new myself.
Clik on cell B1
Choose set in function COUNTA(A:A)

regards jan

 

[Tom Ogilvy]

=countif(A:A,"<>")

or

=CountA(A:A)