| 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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding 2 different letters in a range
I am not sure if this is what you mean? I hope it helps.
=COUNTIF(B2:B39,"g") + COUNTIF(B2:B39,"a") "Bampah" wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding 2 different letters in a range
On 8 Oct, 12:47, Boying Opaw
wrote: I am not sure if this is what you mean? I hope it helps. =COUNTIF(B2:B39,"g") + COUNTIF(B2:B39,"a") "Bampah" wrote: 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? Thanks, that's exactly what I wanted. So simple..........................like me I guess Rob |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding 2 different letters in a range
=SUM(COUNTIF(B2:B20,{"a","g"}))
"Bampah" wrote: 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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding 2 different letters in a range
On 8 Oct, 13:51, Teethless mama
wrote: =SUM(COUNTIF(B2:B20,{"a","g"})) "Bampah" wrote: 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? Thanks Mama That looks more elegant. What is the purpose of the 'sqiggly' parenthsis Rob |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding 2 different letters in a range
The braces define an array.
-- David Biddulph "Bampah" wrote in message ... On 8 Oct, 13:51, Teethless mama wrote: =SUM(COUNTIF(B2:B20,{"a","g"})) "Bampah" wrote: 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? Thanks Mama That looks more elegant. What is the purpose of the 'sqiggly' parenthsis Rob |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding 2 different letters in a range
On 8 Oct, 17:45, "David Biddulph" <groups [at] biddulph.org.uk wrote:
The braces define an array. -- David Biddulph "Bampah" wrote in message ... On 8 Oct, 13:51, Teethless mama wrote: =SUM(COUNTIF(B2:B20,{"a","g"})) "Bampah" wrote: 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? Thanks Mama That looks more elegant. What is the purpose of the 'sqiggly' parenthsis Rob Thankyou David |
| Reply |
| 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) | |||
Linear Mode
