Using the Countif, Countifs option for Excel

M

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
 
A

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
 
M

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
 
R

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

mlkkrs

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top