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