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

On Tue, 19 Feb 2008 17:28:01 -0800, wildauk
wrote:

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.

Hi
maybe
=COUNTA(A1:A10)

--
Regards
Roger Govier

"wildauk" wrote in message
...
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.

=counta(a1:a10)

It'll count the cells with formulas, too.

wildauk wrote:

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.

--

Dave Peterson