Prev: existing connections
Next: Can I SUM column C IF Column A=X AND Column D=Y?
From: "David Biddulph" groups [at] on 8 Oct 2009 12:45
The braces define an array.
--
David Biddulph

"Bampah" <rob.sowerby(a)gmail.com> wrote in message
news:184ffb62-493b-4b5f-a4cb-55e71fff26bb(a)v20g2000vbs.googlegroups.com...
> 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


From: Bampah on 8 Oct 2009 17:20
On 8 Oct, 17:45, "David Biddulph" <groups [at] biddulph.org.uk> wrote:
> The braces define an array.
> --
> David Biddulph
>
> "Bampah" <rob.sowe...(a)gmail.com> wrote in message
>
> news:184ffb62-493b-4b5f-a4cb-55e71fff26bb(a)v20g2000vbs.googlegroups.com...
>
> > 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

Thankyou David
First  |  Prev  | 
Pages: 1 2
Prev: existing connections
Next: Can I SUM column C IF Column A=X AND Column D=Y?