Formular to count occurence of a number or letter in a column

B

Bethrand

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?
 
A

Ashish Mathur

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
 

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

Similar Threads

How to type each letter of the alphabet automatically in a specific color in Word? 0
assign occurence number 3
Assign a number each letter on list compounding occurence @ each e 4
Newbie question - column letter displayed instead of number 1
COUNT unique letter in a column 6
Copy corresponding cell in Column B if cell in A contains certain text? 1
find all instances of a search item and put result in a single cel 5
How to seperate ALPHANUMERIC data in a cell in an excel sheet. 3

Top