Hi Arvi,

Why did you say

=COUNTIF(A1:A96,"*"&"VVN"&"*")

instead of

=COUNTIF(A1:A96,"*VVN*")

just wondering?

Bob

"Arvi Laanemets" wrote in message
...
Hi

=COUNTIF(A1:A96,"*"&"VVN"&"*")

--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


"Paul W" wrote in message
...
I'm trying yo count the number of occurances of a string in a variable
string
e.g look for "VVN" in TDCS0/VVN/8375 or mycompany/VVN/8375 or even
mycompany/TDCS0/VVN/8375. The text does not appear in the same location
each
time. so what i am looking for is countif(a1/a96="VVN anywhere in this
string")

Excel 2002

Help !