Count if cell contains text string

[stuartw]

Hi guys

Probably an easy one for you lot but here goes.

I have 1000 rows of text containing different things (text). I want to count the cell if it contains a text string.

eg Cell contains "Microsoft Navision". I want to search to see if the cell contains "nav" (just the string as opposed to the whole product)

Can anyone help?

Thanks in advance
Stu

 

[sjbutler69]

COUNTIF(A1:A10,"Collections")

How can I modify to count all that contain Collections within table?

Example: I want to know how many new project have Collections. Then how many have ESI. Etc. Knowing there will be overlap.

Collections

Collections; Consulting; ESI; Hosting

Collections; ESI

Collections; ESI; Forensics; Hosting

Collections; ESI; Hosting

Collections; Forensics

Collections; Hosting

Consulting

DIY Infrastructure as a Service (IaaS); Managed Services Agreement

ESI

ESI; Hosting

ESI; Managed Review/Doc Review

<colgroup><col></colgroup><tbody>
</tbody>