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

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

"Margarita Curbelo" wrote:

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

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


"Margarita Curbelo" wrote in
message ...
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.-