Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Flutie99
 
Posts: n/a
Default Counting text only

I'd like to cont text only in a column. Is there a countif/istext combo I
can use?
  #2   Report Post  
bj
 
Posts: n/a
Default

try
=countA(range)-count(range)

"Flutie99" wrote:

I'd like to cont text only in a column. Is there a countif/istext combo I
can use?

  #3   Report Post  
Flutie99
 
Posts: n/a
Default

duh...still hungover. thanks!

"bj" wrote:

try
=countA(range)-count(range)

"Flutie99" wrote:

I'd like to cont text only in a column. Is there a countif/istext combo I
can use?

Reply
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
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
COUNTING TEXT CELLS IN A COLUMN Maureen Excel Worksheet Functions 4 May 9th 05 06:25 PM
Counting NUMBERS &/or TEXT from a column to other sheet ? Trixie Excel Worksheet Functions 4 March 3rd 05 07:59 PM
Excel - counting cells containing a text string Pegasus Host Excel Worksheet Functions 4 February 12th 05 07:31 PM
Counting Repeated text or duplicates in a list Repeatdude Excel Discussion (Misc queries) 5 November 26th 04 07:10 PM


All times are GMT +1. The time now is 01:04 PM.

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

About Us

"It's about Microsoft Excel"