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!

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

regards jan
"Chuck" skrev i melding
...

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!

=countif(A:A,"<")

or

=CountA(A:A)


--
Regards,
Tom Ogilvy


"Chuck" wrote in message
...

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!