| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding 2 different letters in a range
I have been using the following formula to find the total occurrences
of the letter "g" in a range =COUNTIF(B2:B39,"g") I now need to also look for the letter "a" to give a return of them both combined. How do I achieve this please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I not show certain Letters in a range of cells in excel? | Excel Worksheet Functions | |||
| vlookup returns #N/A if value contains letters and range numbers | Excel Discussion (Misc queries) | |||
| Finding most common occurence of values in cells containing letters and numbers | Excel Worksheet Functions | |||
| finding out the combination of letters! | Excel Worksheet Functions | |||
| Finding Numbers with Cells that also contain letters | Excel Discussion (Misc queries) | |||
Threaded Mode
