Re: count occurances of string

[Andy Armstrong <a.armstrong@SHOTOVERJET.CO.NZ>]

Nice use of the wildcard Shane, and in a "ordinary" formula as well 
Just one point - I believe that your formula works only if the string you are searching for is in the first  (or left most characters) of the range being searched - so I modified it to 

=COUNTIF(A200:BZ200,"*"&A1&"*")

 - but all credit must go to you, and I didn't make it totally clear that there may be other charates in front of the chicks or photo example I gave you


I'm off home now 
Regards Andy

-----Original Message-----
From: MS Excel General Q & A List [mailto:EXCEL-G@PEACH.EASE.LSOFT.COM]On Behalf Of Shane Devenshire
Sent: Thursday, July 24, 2003 4:25 PM
To: EXCEL-G@PEACH.EASE.LSOFT.COM
Subject: Re: count occurances of string

Hi Andy Armstrong,

Of course you might want to use:

=COUNTIF(A200:BZ200,A1&"*")

Sincerely,
Shane Devenshire

> Hi All
> In a row say A200:BZ200 I have in each cell the answers to a question in a
> survey.  Cell A200 might be "Seeing the chicks" cells AS200 might be
> "photograph the chickens" cell BA might be "Photo"
>

--------------------------------------------------------------------------
The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info
and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

--------------------------------------------------------------------------
The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info
and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G