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.

Advertisements