Count values in a cell

[Guest]

I need a formula to do the following.

I have a list:
A
B
B
C
A

I need, in a separate cell, to count each instance of A's or B's or C's that
appear. I assume this have to be done using If and Count formulta, but can´t
figure it out.

Thanks in advance for your help.

Regards,
Emece.-

 

[Guest]

Check out Coutif() in helfp
=countif(range,"A")
etc.

 

[Bob Phillips]

=COUNTIF($A:$A,"A")

or put A in a cell and use

=COUNTIF($A:$A,M1)

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)