|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 16th, 2006, 10:08 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
How do I count nonblank text cells in Excel
I am trying to count text information in a column. Using =CountA (H1:H500),
the figure comes out much too high. 
|
|
#2
January 16th, 2006, 10:15 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count nonblank text cells in Excel
Then the cells likely aren't really blank. With that formula in place, try
selecting a couple of the "blank" cells and hitting Edit--Clear--All. Save the file and hit F9. ************ Hope it helps! Anne Troy www.OfficeArticles.com "gerns" wrote in message ... I am trying to count text information in a column. Using =CountA (H1:H500), the figure comes out much too high.
|
|
#3
January 17th, 2006, 12:48 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count nonblank text cells in Excel
You say that you wish to count "text" information in a column, yet you are
using COUNTA() ! That function counts *everything* ... numbers, text, logicals, errors, and zero length strings ( "" ). If you're really looking to count *only* text, try this: =COUNTIF(H1:H500,"*?") -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "gerns" wrote in message ... I am trying to count text information in a column. Using =CountA (H1:H500), the figure comes out much too high.
|
|
#4
November 7th, 2008, 03:46 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count nonblank text cells in Excel
Thanks a lot, RagDyer -- that did the trick for me!!
"RagDyer" wrote: You say that you wish to count "text" information in a column, yet you are using COUNTA() ! That function counts *everything* ... numbers, text, logicals, errors, and zero length strings ( "" ). If you're really looking to count *only* text, try this: =COUNTIF(H1:H500,"*?") -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "gerns" wrote in message ... I am trying to count text information in a column. Using =CountA (H1:H500), the figure comes out much too high.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need Feedback on table setup | Little Penny | Database Design | 1 | December 28th, 2005 11:32 AM |
| Edit/Add record in form from cmdButton | doodle | General Discussion | 3 | December 28th, 2005 03:06 AM |
| Change font of part of text | John | Powerpoint | 7 | March 15th, 2005 10:10 AM |
| Access reports with a horizontal line after each record??? | Bill via AccessMonster.com | Setting Up & Running Reports | 6 | March 9th, 2005 04:51 PM |
| Excel worksheet in Word linked text boxes | Eduardo Oliveira | Page Layout | 0 | January 5th, 2005 11:23 PM |
Linear Mode
