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 |
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) |