Using the Countif, Countifs option for Excel
 

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

Using the Countif, Countifs option for Excel
 

By using the function of countif

=COUNTIF(A:A,"a")

"mlkkrs" wrote:

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

Using the Countif, Countifs option for Excel
 

See your other post

--
Biff
Microsoft Excel MVP


"mlkkrs" wrote:

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

Using the Countif, Countifs option for Excel
 

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

Using the Countif, Countifs option for Excel
 

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

"Naveen" wrote:

By using the function of countif

=COUNTIF(A:A,"a")

"mlkkrs" wrote:

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

Using the Countif, Countifs option for Excel
 

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

Enter with Ctrl + Shift + Enter, not just Enter

Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Ashish Mathur" wrote:

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

Using the Countif, Countifs option for Excel
 

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

"ryguy7272" wrote:

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

Enter with Ctrl + Shift + Enter, not just Enter

Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Ashish Mathur" wrote:

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