What is the formula use to count text cells

[allicat]

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.

 

[Sheeloo]

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

 

[Sheeloo]

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

 

[Gord Dibben]

One method

Count all cells then subtract the number cells.

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


Gord Dibben MS Excel MVP

 

[Gord Dibben]

One method

Count all cells then subtract the number cells.

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


Gord Dibben MS Excel MVP

 

[Ragdyer]

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.

 

[Ragdyer]

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.