Using the Countif, Countifs option for Excel

[mlkkrs]

I am attempting to count how many a's, b's, c's, d's etc are in a column. How
do I get stated doing this? Any help is well appreciated.

Thank you

 

[Naveen]

By using the function of countif

=COUNTIF(A:A,"a")

 

[T. Valko]

See your other post

 

[Ashish Mathur]

Hi,

You can also create a pivot table. Drag the column (containing a,b,c etc.)
to the row area and then again to the data area

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[mlkkrs]

I must be missing a step somewhere because I did that and nothing happened.
Am I supposed to highlight something first? Is there another step after that?
Please help.

Thank you

 

[ryguy7272]

Count all 'a' in a range:
=SUM(LEN(A1:A10)-LEN(SUBSTITUTE(A1:A10,"a","")))

Enter with Ctrl + Shift + Enter, not just Enter

Ryan---

 

[mlkkrs]

Thank you Ryan. Your suggestion was all the help I needed, it worked perfectly.
Kris