Count values in a cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Margarita Curbelo - 15 Aug 2005 17:42 GMT

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

Reply to this Message

bj - 15 Aug 2005 17:56 GMT

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

> I need a formula to do the following.
>
[quoted text clipped - 13 lines]
> Regards,
> Emece.-

Reply to this Message

Bob Phillips - 15 Aug 2005 18:02 GMT

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

or put A in a cell and use

=COUNTIF($A:$A,M1)

etc.

Signature

HTH

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

> I need a formula to do the following.
>
[quoted text clipped - 13 lines]
> Regards,
> Emece.-

Reply to this Message