| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formular to count occurence of a number or letter in a column
Somebody help please!
I am using excel 2003 version and working with a sheet that contains letters 'A' and 'B' mixed up in a column. I would like to sum total number of letters 'A' in one cell and 'B' in another cell, both down the same column. How do I do this, please? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formular to count occurence of a number or letter in a column
use countif function
=COUNTIF(A1:A5,"A") =COUNTIF(A1:A5,"B") On Sep 12, 1:03*pm, Bethrand wrote: Somebody help please! I am using excel 2003 version and working with a sheet that contains letters 'A' and 'B' mixed up in a column. I would like to sum total number of letters 'A' in one cell and 'B' in another cell, both down the same column. How do I do this, please? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formular to count occurence of a number or letter in a column
Hi,
You can create a pivot table. Drag the column to the row area and drag it once again to the data area. This will count the numbers of A's and B's -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Bethrand" wrote in message ... Somebody help please! I am using excel 2003 version and working with a sheet that contains letters 'A' and 'B' mixed up in a column. I would like to sum total number of letters 'A' in one cell and 'B' in another cell, both down the same column. How do I do this, please? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to count the number of occurences of a letter ? | Excel Discussion (Misc queries) | |||
| letter number count | Excel Worksheet Functions | |||
| Assign a number each letter on list compounding occurence @ each e | Excel Worksheet Functions | |||
| How do I count the number of times a letter is used in a cell? | Excel Discussion (Misc queries) | |||
| column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
Linear Mode
