HOW TO COUNT INSIDE A CELL

  • Thread starter Thread starter Lee
  • Start date Start date
L

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.
 
Try these:

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

=LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),UPPER("D"),""))
 
Lee said:
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.
Click to expand...

Thanks for the quick response. It works wonderfully. Much appreciate it
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.
Click to expand...


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
 
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.
Click to expand...

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