View Single Post
  #2   Report Post  
bj
 
Posts: n/a
Default

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