Counting in cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to count the alpha characters in a range of cells.
For ex:
a1 = M C D M M
a2 = M C C
then C=3, D=1 and M =4.

Bud Phillips has LEN(A1)-LEN(SUBSTITUTE(A1,"G","")) which works great for
one cell, but I can't get it to work for a range.

If I use +COUNTIF($A$1:$A$2,"*M*") it does not count multiples in a cell it
would =2.

Any help is truly appreciated.

Thanks
 
One way

=SUMPRODUCT(--(LEN(A1:A10)-LEN(SUBSTITUTE(A1:A10,"G",""))))
 
You must log in or register to reply here.

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

Scrabble Value calculation for Welsh words 0
After sort and concant, one too many semi-colon 15
VBA Syntax for Countif condition where only 1st char in Range of each cell = "M" 5
Bold items within text string 7
Excel Need Countifs Formula Help 0
Array with many cells from a row but not in order or together 11
Letters in the code 3
Counting Criteria Values with For Loop 3

Back
Top