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?
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" <Ispencer@discussions.microsoft.com> wrote in message news:6CDDC7EB-58F0-449B-9D6D-5F9F32C53803@microsoft.com...
>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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks