Number of names in a column

[Chuck]

I've a number of names in column B. How can I count how names I've
entered and then put that result in a cell in another worksheet?
Thanks for the help.

 

[Paul]

I've a number of names in column B. How can I count how names I've
entered and then put that result in a cell in another worksheet?
Thanks for the help.

does this give what you want?
=COUNTA($B:$B)

 

[Peo Sjoblom]

=COUNTA(B2:B500)

 

[Gord Dibben]

In addition, to put it in another worksheet you must place this formula in a
cell on the other worksheet.

=COUNTA(Sheet1!B2:B500)

Gord Dibben Excel MVP