How i count cells that includes a specific text?

  • Thread starter Thread starter Excadrix
  • Start date Start date
E

Excadrix

Hello everyone... I have this problem and i cant find a solution...

I have a list like the following

Comedy
Action / Drama / Animation / Sci-Fi
Crime/Action/Thriller
Adventure / Animation / Comedy / Fantasy
Drama
Action / Drama / War
Comedy / Family
Action / Comedy / Thriller / Crime
Action / Thriller
Drama / Action / War
Drama / Thriller / Action / Adventure / Horror
Action / Adventure / Fantasy / Crime / Romance / Thriller
Action / Adventure / Drama / Romance
Drama
Drama
Action / Sci-Fi / Horror
Action / Thriller / Horror

(every line is a cell )

my problem is that i want to count how many cells have the word pe
example "Action" in them.... is any way to do it?

Thanx in advance...
 
Back
Top