What is the formula use to count text cells
 

Member Name & Company
James W. Bond
Robert Wagner
Mark Brown
Carl. Boyle,
Anthony Perkinks
5

I need a formula that will count a range of cells with names text only, like
the exaple above.

What is the formula use to count text cells
 

Assuming your data is in A2:A100
then
=COUNTA(A2:A1100)
will give you the count of non-empty cells
and
=COUNT(A2:A1100)
will give you the count of cells with numbers
so
=COUNTA(A2:A1100) - COUNT(A2:A1100)
will give you the count of cells containing only TEXT

"allicat" wrote:

Member Name & Company
James W. Bond
Robert Wagner
Mark Brown
Carl. Boyle,
Anthony Perkinks
5

I need a formula that will count a range of cells with names text only, like
the exaple above.

What is the formula use to count text cells
 

One method

Count all cells then subtract the number cells.

=COUNTA(A1:A7)-COUNT(A1:A7)


Gord Dibben MS Excel MVP

On Wed, 20 May 2009 12:43:09 -0700, allicat
wrote:

Member Name & Company
James W. Bond
Robert Wagner
Mark Brown
Carl. Boyle,
Anthony Perkinks
5

I need a formula that will count a range of cells with names text only, like
the exaple above.

What is the formula use to count text cells
 

This will count only text cells:

=COUNTIF(A:A,"*")

You should take note that this will also count "nulls" ( "" ) (zero length
strings),
which may be returned by formulas since XL considers these as TEXT.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"allicat" wrote in message
...
Member Name & Company
James W. Bond
Robert Wagner
Mark Brown
Carl. Boyle,
Anthony Perkinks
5

I need a formula that will count a range of cells with names text only,
like
the exaple above.