CountIf(A1:H1,"A")

adjust to suit

--

Regards,
Nigel




"lifeguardernie" wrote in message
...
how can i have excel count letters instead of numbers
if i have a row of cells a b a a b c a
b
how can i set up a cell to give me the total number of all the a's in the
row