View Single Post
  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

Do you mean count the instances of a letter, such as

=SUMPRODUCT(LEN(A1:A100)-LEN(SUBSTITUTE(A1:A100,"a","")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Iviio" wrote in message
...
I can use formulas to calculate numbers or figures. How do I sum up

letters
in a range of cells?