counting names

  • Thread starter Thread starter wildauk
  • Start date Start date
W

wildauk

Hi, I need to count how many cells have a name or any word in them, so say I
have cells A1 to A10 and every time I put any letters in any of the cells it
is recorded in say A32 as (1), is there any way I can do this?

Thank you in advance, Barry.
 
In A32 enter =COUNTA(A1:A10) which will count the cells with anything,
including a numbers or a space.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If 3
counting 2
Count fowmula that will look for multiple words 2
Counting Specific Text 2
Function for summing or counting cells based on a specified fill color 2
Excel Need Countifs Formula Help 0
counting 3
counting letters in excel cell 1

Back
Top