| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count only Letters in cells that contain both letters and numbers
Hello to all.
I have a Column that has cells with both numbers and letters, like this: W 6-2 L 3-7 W 11-6 W 1-0 I want to add up the number of W's that appear in this range. Don't seem to be able to figure it out. Can anyone help? Thanks! -- TommyB |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count only Letters in cells that contain both letters and numbers
TommyB wrote:
Hello to all. I have a Column that has cells with both numbers and letters, like this: W 6-2 L 3-7 W 11-6 W 1-0 I want to add up the number of W's that appear in this range. Don't seem to be able to figure it out. Can anyone help? Thanks! Assuming you only want to count a cell once when it contains at least one "W", try this: =COUNTIF(A1:A4,"*W*") |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count only Letters in cells that contain both letters and numb
You Rock...that was so simple.
Thanks a million -- TommyB "smartin" wrote: TommyB wrote: Hello to all. I have a Column that has cells with both numbers and letters, like this: W 6-2 L 3-7 W 11-6 W 1-0 I want to add up the number of W's that appear in this range. Don't seem to be able to figure it out. Can anyone help? Thanks! Assuming you only want to count a cell once when it contains at least one "W", try this: =COUNTIF(A1:A4,"*W*") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count the letters in the cells and sum in another cell | Excel Worksheet Functions | |||
| How to count specific letters in range of cells? | Excel Discussion (Misc queries) | |||
| How do I count letters and numbers in a formula? | Excel Worksheet Functions | |||
| How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
| Finding Numbers with Cells that also contain letters | Excel Discussion (Misc queries) | |||
Linear Mode
