Excell: count occurance of letters in a column
 

I would like to have Excell count an occurance of letters in a column, like
subtotal only without splitting the data, simply give a total of occurances
of a letter in the column. Can this be done?

Yes this is possible

Use this array formula, use CTRL-SHIFT-ENTER instead of ENTER for the letter a

=SUM(LEN(A1:A10)-LEN(SUBSTITUTE(A1:A10,"a","")))

More info about them you can find here
http://www.cpearson.com/excel/array.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ispencer" wrote in message ...
I would like to have Excell count an occurance of letters in a column, like
subtotal only without splitting the data, simply give a total of occurances
of a letter in the column. Can this be done?