Prev: existing connections
Next: Can I SUM column C IF Column A=X AND Column D=Y?
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 <BoyingO...(a)discussions.microsoft.com>
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
<Teethlessm...(a)discussions.microsoft.com> 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 connections
Next: Can I SUM column C IF Column A=X AND Column D=Y?