PC Review


Reply
Thread Tools Rate Thread

counting text strings

 
 
Keith Rathband
Guest
Posts: n/a
 
      21st Jun 2007
This is probably really simple - but how can i count how many cells in colum
contain a certian text varible ?



 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      21st Jun 2007
=countif(a:a,"sometext")
will count the number of cells in column A that are equal to "sometext"

=countif(a:a,"*sometext*")
will count the number of cells in column A that contain "sometext"

Keith Rathband wrote:
>
> This is probably really simple - but how can i count how many cells in colum
> contain a certian text varible ?


--

Dave Peterson
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting consecutive strings of text SamG Microsoft Excel Misc 2 29th Jan 2010 04:50 AM
Counting consecutive strings of text SamG Microsoft Excel Misc 2 27th Jan 2010 07:25 AM
Counting Text Strings =?Utf-8?B?S2hvbG0=?= Microsoft Excel Worksheet Functions 11 21st Aug 2007 05:56 PM
Re: Counting text strings JE McGimpsey Microsoft Excel Worksheet Functions 0 21st Apr 2006 05:35 AM
counting occurances of text strings Gr8gonzo Microsoft Excel Worksheet Functions 3 5th Jan 2004 03:38 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:16 PM.