Formulae help

[kittygeek]

My boss has asked me to use Excel to automatically created percentages which is fine. But the data is text - e.g. a B, I or A ionstead of numbers.
Is there a way of getting Excel to work out the number of each letter and then convert to percentages?
My boss thinks I can do anything on Excel.

 

[VoG]

Does this help at all? If not, what numerical value should be assigned to each letter?

Excel Workbook
	A	B
1	B	2
2	I	9
3	A	1
Sheet3

 

[kittygeek]

Hi basically the spreadsheet has to show children's achievement levels so B = below, I = inline and A = above.
My boss wants to be able to enter either B, I or A and then get an auto calculation of the percentages.
So basically I just want to be able to count the number of letters in a column.

 

[VoG]

Try like this

=COUNTIF(A:A,"B")

 

[kittygeek]

Thank you very much, that ios fab - my boss wil think I'm a genuius
Thanks you're a star.