counting text strings

's Computer Specifications

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

's Computer Specifications

=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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

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