| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting in cells
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting the number of cells between 2 seperate cells | Excel Discussion (Misc queries) | |||
| counting cells that are 0 in a range of non-contiguous cells | Excel Worksheet Functions | |||
| Query counting cells in a row that exactly match cells in another | Excel Discussion (Misc queries) | |||
| Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
Threaded Mode
