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?

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?

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?