Number of names in a column

  • Thread starter Thread starter Chuck
  • Start date Start date
C

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.:confused:
 
Chuck said:
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.:confused:
Click to expand...

does this give what you want?
=COUNTA($B:$B)
 
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
 
Back
Top