Thanks for the input.
The column may actually contain any number of letters. Examples B1 = pme, B2
= e, B3 = pe, etc.
I want to have a few cells that count the p's, m's and e's.

Thanks again,
Brian

"Dave Peterson" wrote in message
...
This will give you the number of lower case a's in a range:
=SUMPRODUCT(LEN(A1:A100)-LEN(SUBSTITUTE(A1:A100,"a","")))/len("a")

If you want to ignore case, you can use:
=SUMPRODUCT(LEN(A1:A100)
-LEN(SUBSTITUTE(upper(A1:A100),upper("a"),"")))/len("a")

(Substitute is case-sensitive)

Adjust the ranges to match--but you can't use whole columns (except in
xl2007+).




Brian wrote:

Howdy All,

I want to count the number of occurrences of a partipular letter in a
column

Any help?

THanks,
Brian

--

Dave Peterson