Counting cells with text

A

ArtBuyer7

Does anyone know the formula to count cells with text in them (as
opposed to x's)? Please help! Thanks!
 
B

Barry Wainwright

Does anyone know the formula to count cells with text in them (as
opposed to x's)? Please help! Thanks!
Click to expand...

=counta(range)-count(range)

Counta counts all non-blank cells, count counts all numbers, which includes
dates, percentages etc.

Note, this will also count formulae that return a text value.
 
B

Bob Greenblatt

If you are trying to distinguish cells containing only an "x" fro other
cells containing text, try using countif.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Text to End of Footnote 9
Copy addition formula of non-consecutive horizontal cells 2
Macro to Select text from a point given to a specific word 2
Vertical Timelines 0
Excel does not accept text format! 0
Macro to count words in a section, excluding footnotes and end notes 1
Content Control Box Issue - Please Help! 0
Newbie Help - IF Yes No Function 0

Top