count only R

P

p3project

Hi, can someone please tell me the formula to count only r in a column
The column contains many other things but I need a ruuning count if th
cell contains only the letter r.

Many thanks for any help

Regards

Davi
 
A

A.W.J. Ales

David,

Assumingyour column is A1:A100

=COUNTIF(A1:A100,"r")

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Top