From: Bampah on 8 Oct 2009 07:38 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? From: Boying Opaw on 8 Oct 2009 07:47 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? > From: Bampah on 8 Oct 2009 08:02 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 From: Teethless mama on 8 Oct 2009 08:51 =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? > From: Bampah on 8 Oct 2009 11:40 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  |  Next  |  Last Pages: 1 2 Prev: existing connectionsNext: Can I SUM column C IF Column A=X AND Column D=Y?