Finding 2 different letters in a range

  • Thread starter Thread starter Bampah
  • Start date Start date
B

Bampah

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?
 
I am not sure if this is what you mean? I hope it helps.

=COUNTIF(B2:B39,"g") + COUNTIF(B2:B39,"a")
 
I am not sure if this is what you mean? I hope it helps.

=COUNTIF(B2:B39,"g") + COUNTIF(B2:B39,"a")

Thanks, that's exactly what I wanted.
So simple..........................like me I guess

Rob
 
Back
Top