How do I do a count if Cell contains text in Excel?

Question

I want to count all occurances in a column that contains a specific Text string. i.e. I want to count how many cells contain "AA" in a specific column.

From the 2 answeres recieved so far, I would like to expand. I will need to count a the # text fields for about 20 difference 2 letter text strings. Each text field can contain more than one, and contrian the same one twice (which only gets counted once). Logicaly, I want to do Countif(Range, cell contains text string)

Answer 1

select autofilter, select custom, select contains "AA"
All the AA are now filtered. Select the whole colum. All the bottom of the window where you see the bar with the word 'Ready' on the left
Rightclick on it, select 'Count'.

Answer 2

Count If Cell Contains Text

Answer 3

This Site Might Help You.

RE:
How do I do a count if Cell contains text in Excel?
I want to count all occurances in a column that contains a specific Text string. i.e. I want to count how many cells contain "AA" in a specific column.

Answer 4

=COUNTA(Range Begin, Range End)