=LEN(A1)-LEN(SUBSTITUTE(A1,"a",""))

if you want a label for it

="Monthly Total of a = " & LEN(A1)-LEN(SUBSTITUTE(A1,"a",""))

"Laura Henderson" wrote:

I need to count how many times 1 cell has letter a, b, c, d, and so on. Is
there any way to do this without using multiple cells? Also, is there a way
to name each total? For example, a = Monthly Total of A. Thanks!