meant COUNTIF

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:ehvyLN%23rFHA.528@TK2MSFTNGP09.phx.gbl...
> =SUMIF(A:A,"*hat*")
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "zubee" <zubee@discussions.microsoft.com> wrote in message
> news:60ABC3EF-9474-403C-BDB9-8091EC034425@microsoft.com...
> > I would like to count the number of records that appear in the same
column
> > for example column "A"
> > A
> > hat and coat
> > coat
> > hat
> > hat and coat
> > gloves
> >
> > The formula that i am looking for would answer the question, how many
> > records contain ("hat and coat" and "hat") the answer would be 3
records.
> > Any help would be greatly appreciated!
> >
> > --
> > Cheers
>
>