Column count usage help

[viv_karthy]

Hi
I have a column with values as below:

Creative, Project Management, Production, Quality
Creative, Rights and Permissions, Project Management, Production, Quality
Creative, Project Management, Production, Quality
Creative Projects, Editorial, Digital and Interactive
Creative Editorial, Project Management, Production, Quality
Project Management, Production, Quality
Creative Editorial, Project Management, Production, Quality
Project Management, Production, Quality
Creative, Project Management
Creative Skills, Project Management
Project Management, Production, Quality
Creative Editorial, Project Management, Production, Quality
Creative Editorial, Project Management, Production, Quality

I need to have a formula that can calculate the count of the word Creative in that column
Ideally of the 13 items listed I should see a count of 11 ie Creative, Creative Skills and Creative Editorial

[Sam Capricci]

try =COUNTIF(A:A,"*creative*")

[alansidman]

Data Range

	A	B	C
1	Creative, Project Management, Production, Quality	1	10
2	Creative, Rights and Permissions, Project Management, Production, Quality	1
3	Creative, Project Management, Production, Quality	1
4	Creative Projects, Editorial, Digital and Interactive	1
5	Creative Editorial, Project Management, Production, Quality	1
6	Project Management, Production, Quality	#VALUE!
7	Creative Editorial, Project Management, Production, Quality	1
8	Project Management, Production, Quality	#VALUE!
9	Creative, Project Management	1
10	Creative Skills, Project Management	1
11	Project Management, Production, Quality	#VALUE!
12	Creative Editorial, Project Management, Production, Quality	1
13	Creative Editorial, Project Management, Production, Quality	1
14	Formulas--->	=FIND("Creative",A14)	=COUNTIF(B1:B13,1)