If the cell contains - r1, r2, r3 count=3 i.e r 3 times
if the cell contains d11,d12,d78.d56- I want to count number of times d
appears a cell.

Try these:

=LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),UPPER("R"),""))

=LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),UPPER("D"),""))

--
Biff
Microsoft Excel MVP


"Lee" wrote in message
...
If the cell contains - r1, r2, r3 count=3 i.e r 3 times
if the cell contains d11,d12,d78.d56- I want to count number of times d
appears a cell.

"Lee" wrote:

If the cell contains - r1, r2, r3 count=3 i.e r 3 times
if the cell contains d11,d12,d78.d56- I want to count number of times d
appears a cell.

Thanks for the quick response. It works wonderfully. Much appreciate it
Lee

On Tue, 14 Jul 2009 18:22:01 -0700, Lee wrote:

If the cell contains - r1, r2, r3 count=3 i.e r 3 times
if the cell contains d11,d12,d78.d56- I want to count number of times d
appears a cell.


First, create a Named Formula
Names in Workbook: Seq
Refers to: =ROW(INDEX($1:$65536,1,1):INDEX($1:$65536,255,1))

A1: your data
B1: letter to find (e.g. d)
C1: =SUMPRODUCT(--(MID(A1,seq,1)=B1))
--ron

On Tue, 14 Jul 2009 18:22:01 -0700, Lee wrote:

If the cell contains - r1, r2, r3 count=3 i.e r 3 times
if the cell contains d11,d12,d78.d56- I want to count number of times d
appears a cell.

Ignore my response. It works, but I was in another world when I composed it
:-)
--ron

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Lee" wrote in message
...


"Lee" wrote:

If the cell contains - r1, r2, r3 count=3 i.e r 3 times
if the cell contains d11,d12,d78.d56- I want to count number of times d
appears a cell.

Thanks for the quick response. It works wonderfully. Much appreciate it
Lee