 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / August 2005Counting cells with text
Does anyone know the formula to count cells with text in them (as opposed to x's)? Please help! Thanks! On 24/8/05 21:51, in article 1124916665.794577.293510@f14g2000cwb.googlegroups.com, "ArtBuyer7" <misslyds7@yahoo.com> wrote: > 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.  SignatureBarry 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/> If you are trying to distinguish cells containing only an "x" fro other cells containing text, try using countif. On 8/25/05 6:42 AM, in article BF335F2B.6CE63%barry@mvps.org.INVALID, "Barry Wainwright" <barry@mvps.org.INVALID> wrote: > On 24/8/05 21:51, in article > 1124916665.794577.293510@f14g2000cwb.googlegroups.com, "ArtBuyer7" [quoted text clipped - 9 lines] > > Note, this will also count formulae that return a text value. SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom THANK YOU! I really appreciate the help! > On 24/8/05 21:51, in article > 1124916665.794577.293510@f14g2000cwb.googlegroups.com, "ArtBuyer7" [quoted text clipped - 15 lines] > Seen the All-New Entourage Help Pages? - Check them out: > <http://www.entourage.mvps.org/> |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.