HOW TO COUNT INSIDE A CELL

[Lee]

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.

 

[T. Valko]

Try these:

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

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

 

[Lee]

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

 

[Ron Rosenfeld]

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

 

[Ron Rosenfeld]

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

 

[T. Valko]

You're welcome. Thanks for the feedback!