I needed to see how many times a bank charged me a fee. To do that I downloaded CVS file of my account history.
Then I used a formula “=IF(EXACT(B36,”Smart Pay Fee “),1,0)” to give me 1 if the cell has “Smart …” exact text. Then I just added all ones to count the ocurance of the cell. To see if cell contains a word, one can use search function. Functions on text can be found here.
Kirill's Blog 