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?

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?

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

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?

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

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

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