caculations letters
 

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

caculations letters
 

=COUNTIF(A1:H1,"a")

RBS


"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

caculations letters
 

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

caculations letters
 

For the whole row...

=COUNTIF(1:1,"a")

Rick


"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