searching for occurances of txt

A

alistair01

Im a bit stuck with this problem, basically i am trying to count the
occurances of txt within a column. This is a database with a misc.
entry and i want a formula that will return the number of times a cell
that contains eg. "z1". there is more text within the cell.
 
B

Bob Phillips

=COUNTIF(A:A,"*z1*")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top