=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