| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, option to enter text in cells the same as text boxes | Excel Worksheet Functions | |||
| How can I remove hidden empty text cells from Excel? | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Excel - counting cells containing a text string | Excel Worksheet Functions | |||
Linear Mode
