Count occurrences of text within a cell

G

Guest

I need to count the number of characters repeating within a cell. For
example, assuming the following in range A1 through A4:

eee
ee
aaaae
af

A count of "e" would return

3
2
1
0
 
P

Peo Sjoblom

If you only use one cell then this will suffice

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

you probably meant


=SUMPRODUCT(LEN(A1:A10)-LEN(SUBSTITUTE(UPPER(A1:A10),"E","")))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT formula I think w/ wild card & number vs number as text 8
count the occurrences of a month in a date&time cell 6
Counting Occurrence of a Value within Cells 1
Search for Condition, Text based, Date Range, Occurrences 1
COUNT function 2
Conditional Counting of Duplicated Names 4
Mulitiple Count of occurrences in different columns 3
Count the number of appearance within a cell 13

Top