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.