Wednesday, December 03, 2008   
  Search   
 
 
Register  Login  
Forums  
     Minimize  

Welcome to MeraWindows forums.

Thank you for being at the Microsoft Windows Community Site. You may have to register before posting in forums. It's absolutely free. After registering, you can get all the benefits available to our registered members, you can access our Downloads section, you can participate in contests, etc. You can post in forums in English as well as in Hindi, in fact we encourage you to use Hindi in your posts. If you have any problem with registration or login, please contact us.
     
  


 
  Microsoft Windows Forums  Microsoft Offic...  Microsoft Excel  Count text values
Previous Previous
 
Next Next
New Post 11/22/2007 5:04 AM
User is offline Ashish Mathur
89 posts
www.ashishmathur.com
Member




Count text values 

Hi,

If a range of data has both text and numbers, then many a times Excel users want to count the number of text entries in the range.  The two workarounds which i know of getting a solution to this problem are:

1.  COUNTA(Range)-COUNT(Range)
2.  COUNTIF(Range,"*")

Hope this helps

For Microsoft Excel trainings in India, please visit http://ashishmathur.com/training.aspx

Regards,

Ashish Mathur - View Ashish Mathur's profile on LinkedIn
Microsoft Excel MVP
www.ashishmathur.com
 
New Post 11/22/2007 2:27 PM
User is offline Vishal Gupta
6366 posts
www.AskVG.com
Ultimate Member








Re: Count text values 

Thanks for this nice tip.

Tweaking with Vishal

How to Use Smiley Code in Forum?
Promote MeraWindows at Your Blog / Site
Read Forum Guidelines
 
New Post 11/22/2007 8:49 PM
User is offline techfreak
1141 posts
gizmos4fun.blogspot.com
MW Addict




Re: Count text values 

wow thats a nice little handy tip indeed usefull one..

Gizmos4fun
 
 Page 1 of 1
Previous Previous
 
Next Next
  Microsoft Windows Forums  Microsoft Offic...  Microsoft Excel  Count text values


   Get Your Own E-Mail Account @MeraWindows.com Minimize  
New Page 1 New Page 1
Show your cool quotient with @merawindows.com email account
     
  
 
 
Terms Of Use   Privacy Statement  
© 2008 MeraWindows.com