counting names

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.
 
G

Gord Dibben

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


Gord Dibben MS Excel MVP
 
Top