Question: How to find how many occurences a text string (AA) is found in a column of cell values?

Answer: Use countif to count the number of cells that meet the given criteria. * is used to find AA in the text string. Otherwise the formula will only count a perfect match.

Counts the number of cells within a range that meet the given condition