LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Karl Burrows
 
Posts: n/a
Default Count Text Values in Column

I converted a column of number cells to text to allow entry of 1a, 1b, etc.
and need to be able to count the totals of these cells. I can't give it
specific criteria to use DCOUNTA since the text value will vary. Is there a
way to get a count of non-blank cells in a column of text values?

Thanks!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count Intervals of Filtered TEXT values in Column and Return Count across a Row Sam via OfficeKB.com Excel Worksheet Functions 9 July 31st 05 03:37 AM
Lookup Table Dilemma Karen Excel Worksheet Functions 2 June 10th 05 08:22 PM
How to count occcurence of specific text block in a column Anshuman Excel Discussion (Misc queries) 2 February 12th 05 12:55 PM
Count the text in a column - Part II Peter Curtis Excel Discussion (Misc queries) 3 January 6th 05 06:58 PM
How do I count the amount of text in a column and then add them Peter Curtis Excel Discussion (Misc queries) 1 January 6th 05 01:06 PM


All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"