A
ArtBuyer7
Does anyone know the formula to count cells with text in them (as
opposed to x's)? Please help! Thanks!
opposed to x's)? Please help! Thanks!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Barry Wainwright
Does anyone know the formula to count cells with text in them (as
opposed to x's)? Please help! Thanks!
=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.
cells containing text, try using countif.
A
ArtBuyer7
THANK YOU! I really appreciate the help!
Barry said:=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.
--
Barry Wainwright
Microsoft MVP (see http://mvp.support.microsoft.com for details)
Seen the All-New Entourage Help Pages? - Check them out:
<http://www.entourage.mvps.org/>