count only R

[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

 

[Frank Kabel]

Hi David
try
=COUNTIF(A1:A1000,"r")

 

[Guest]

Hi David

tr
=COUNTIF(a1:a999,"r"

Regards
Bernd

 

[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 *

 

[p3project]

as usual, very quick help, thank you

Regards

Dav