Re: count occurances of string

[George Ioanidis <george.ioanidis@BOMBARDIER.COM>]

Sweeeeet Shane!  Peter I think you can just add the wildcard before A1 as
well
=COUNTIF(B141:D145,"*"&A140&"*")
George


Date:    Thu, 24 Jul 2003 13:25:36 +0800
From:    "Wall, Peter" <Peter.Wall@SNCLAVALIN.COM>
Subject: Re: count occurances of string

Shane,

To account for entries not starting with A1 you'd need to add them too,
And then subtract any double counted entries (those that exactly match).

That is,
=COUNTIF(A200:BZ200,A1&"*")+COUNTIF(A200:BZ200,"*"&A1)-COUNTIF(A200:BZ200,A1
)

I think...

Pete

-----Original Message-----
From: Shane Devenshire [mailto:ShaneDevenshire@CS.COM]
Sent: Thursday, 24 July 2003 12: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