Thread: How to count specific letters in range of cells?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Renee R.[_2_] Renee R.[_2_] is offline
external usenet poster
  
Posts: 4
Default How to count specific letters in range of cells?
I am looking for a formula to count the number of R's in a range.
=countif(a1:a3,"*R*")... is only giving me 2 - one for each cell there is an
"R"... not 5 for the total number of R's. I need a formula to give me that
"total" - 5 number. Any ideas????

A1 = BETH PAGEL (zero R's)
A2 = BARRY GUNTHER (3 R's)
A3 = RANDY ROST (2 R's)
Reply With QuoteReply With Quote