Count values in a cell

M

Margarita Curbelo

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.-
 
B

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)
 
Top