| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get started using the Countif, Countifs option with Excel | Excel Worksheet Functions | |||
| COUNTIFS - Excel 07 | Excel Discussion (Misc queries) | |||
| Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr | Excel Worksheet Functions | |||
| Countif compares to Countifs | Excel Worksheet Functions | |||
| Replacing COUNTIFS with COUNTIF | Excel Worksheet Functions | |||
Linear Mode
