Counting Words

[JeffB]

I’ve been searching the web, but just can’t find the right answer.
I have a column with a 1000+ US state abbreviation (example, FL, GA, NC) I need to create a formula that will tell me how many times the state abbreviation appears within the column.
For example:
FL = 300
GA = 132
Any help would be greatly appreciated

 

[Special-K99]

=countif(a1:a1000,"=fl")

or for a more "formal" report
use Pivot Tables