(Excel 2K) Calculating the occurance of a letter in a coloumn.

[msimmons]

I have a column that is filled with ABC or D for each row. these values are random and I need to find out how many of each for a set amount of rows... is this possible?
example:

row# : value
1 B
2 D
3 D
4 A
5 B
6 D
7 A
8 C
9 A
10 D

so I need to get
A = 3
B = 2
C = 1
D = 4

thanks in advance,
Michael

[JoshT]

=COUNTIF(A1:A10,"A")

the COUNTIF function seems to do what you what. The above counts the "A"s in the first ten rows of column A.

[msimmons]

Awesome thanks!