Count cells only containing text

[FeS2]

I have need to count the cells of a column that contains a list of names, none of the names are the same, it also contains a list of numbers. I would like to count only how many cells contain a text value, not a specific value just text. Is there a way to do that?

 

[dyarwood]

Try this function

=COUNTIF(A:A,"*&quot

might work

dyarwood

 

[xlbo]

this should do the trick:
=SUMPRODUCT((ISTEXT(A1:A100))*(1))

where your data is in A1:A100

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[FeS2]

Ok i tried both, it counted every cell. I figured out that all the cells a general format, could excel think they are all text then if they contain any value? This spreadsheet was generated from a report run against a huge database and has around 10000 rows. It would be inpractical for me to try and change the formating for the individual cells manually.

 

[smah]

How about:
=COUNTA(A1:A100)-COUNT(A1:A100)

(again where data is in A1 - A100)

 

[FeS2]

tried it, it counted every cell containing any data.

 

[FeS2]

whew, thanks for the help, a coworker here had an idea that worked great. I added a new column and then put in this formula =IF((ISERROR(B10/2)), "x", (B10/55)). After that returns #value when it can't divide it puts an x in the cell and then i used a =COUNTIF(C:C, "x&quot to get the count I needed. Thanks for everyones help.