Excel question!

[chrisdarkfire]

Any Excel buffs out there?

If have a column of text, for example:

A
B
B
C
C
A
B

is there any way of totalling the number of each letter?

So I get A=2, B=3 and C=2 without a long formula?