(Msg. 1) Posted: Thu Oct 29, 2009 10:09 am
Post subject: Multiple text function calculation Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
Dear all,
Please, if you could help in searching and making the correct formula:
I have two columns with different text values:
Col. A
Product A
Product B
Product C
Product A
Product A
Product B
Col. B
Paris – sector 1.
London – sector 1.
Rome – sector 1.
London – sector 2.
London – sector 3.
Paris – sector 1.
What is the aim:
To count how much times product A occurs in London (also to count all
sections)?
I've tried with countif and sumproduct, but no results. (((
(Msg. 2) Posted: Thu Oct 29, 2009 10:27 am
Post subject: RE: Multiple text function calculation [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
> Dear all,
>
> Please, if you could help in searching and making the correct formula:
>
> I have two columns with different text values:
> Col. A
> Product A
> Product B
> Product C
> Product A
> Product A
> Product B
>
> Col. B
> Paris – sector 1.
> London – sector 1.
> Rome – sector 1.
> London – sector 2.
> London – sector 3.
> Paris – sector 1.
>
> What is the aim:
> To count how much times product A occurs in London (also to count all
> sections)?
>
> I've tried with countif and sumproduct, but no results. (((
>
>
> Thank you very much for your answers and help!
>
> Kindly,
> ekonomija
>
(Msg. 3) Posted: Thu Oct 29, 2009 10:27 am
Post subject: Re: Multiple text function calculation [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"ekonomija" <ekonomija.RemoveThis@discussions.microsoft.com> wrote in message
news:598A73E2-E495-4A7B-A7AA-57F6E2085CE3@microsoft.com...
> Dear all,
>
> Please, if you could help in searching and making the correct formula:
>
> I have two columns with different text values:
> Col. A
> Product A
> Product B
> Product C
> Product A
> Product A
> Product B
>
> Col. B
> Paris - sector 1.
> London - sector 1.
> Rome - sector 1.
> London - sector 2.
> London - sector 3.
> Paris - sector 1.
>
> What is the aim:
> To count how much times product A occurs in London (also to count all
> sections)?
>
> I've tried with countif and sumproduct, but no results. (((
>
>
> Thank you very much for your answers and help!
>
> Kindly,
> ekonomija
>
(Msg. 4) Posted: Thu Oct 29, 2009 11:00 am
Post subject: RE: Multiple text function calculation [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thank you very much!!!! It helped!
It is so easy! I've struggled with it all day long!!
Best,
ekonomija
Korisnik "Teethless mama" napisao je:
> =SUMPRODUCT((A2:A7="Product A")*(LEFT(B2:B7,6)="London"))
>
>
> "ekonomija" wrote:
>
> > Dear all,
> >
> > Please, if you could help in searching and making the correct formula:
> >
> > I have two columns with different text values:
> > Col. A
> > Product A
> > Product B
> > Product C
> > Product A
> > Product A
> > Product B
> >
> > Col. B
> > Paris – sector 1.
> > London – sector 1.
> > Rome – sector 1.
> > London – sector 2.
> > London – sector 3.
> > Paris – sector 1.
> >
> > What is the aim:
> > To count how much times product A occurs in London (also to count all
> > sections)?
> >
> > I've tried with countif and sumproduct, but no results. (((
> >
> >
> > Thank you very much for your answers and help!
> >
> > Kindly,
> > ekonomija
> >
(Msg. 5) Posted: Thu Oct 29, 2009 12:15 pm
Post subject: RE: Multiple text function calculation [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
You're Welcome!
"ekonomija" wrote:
> Thank you very much!!!! It helped!
>
> It is so easy! I've struggled with it all day long!!
>
> Best,
> ekonomija
>
> Korisnik "Teethless mama" napisao je:
>
> > =SUMPRODUCT((A2:A7="Product A")*(LEFT(B2:B7,6)="London"))
> >
> >
> > "ekonomija" wrote:
> >
> > > Dear all,
> > >
> > > Please, if you could help in searching and making the correct formula:
> > >
> > > I have two columns with different text values:
> > > Col. A
> > > Product A
> > > Product B
> > > Product C
> > > Product A
> > > Product A
> > > Product B
> > >
> > > Col. B
> > > Paris – sector 1.
> > > London – sector 1.
> > > Rome – sector 1.
> > > London – sector 2.
> > > London – sector 3.
> > > Paris – sector 1.
> > >
> > > What is the aim:
> > > To count how much times product A occurs in London (also to count all
> > > sections)?
> > >
> > > I've tried with countif and sumproduct, but no results. (((
> > >
> > >
> > > Thank you very much for your answers and help!
> > >
> > > Kindly,
> > > ekonomija
> > >
(Msg. 6) Posted: Fri Oct 30, 2009 12:53 am
Post subject: Re: Multiple text function calculation [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thank you very much!
But, I have a problem... #VALUE error occurs... I have couple of blank
cells... does this effect somehow to this formula?!
Thank you¨!
Kindly,
ekonomija
"Peo Sjoblom" wrote:
> =SUMPRODUCT(--(A1:A50="Product A"),--(ISNUMBER(SEARCH("London",B1:B50))))
>
>
>
> --
>
>
> Regards,
>
>
> Peo Sjoblom
>
>
> "ekonomija" <ekonomija.DeleteThis@discussions.microsoft.com> wrote in message
> news:598A73E2-E495-4A7B-A7AA-57F6E2085CE3@microsoft.com...
> > Dear all,
> >
> > Please, if you could help in searching and making the correct formula:
> >
> > I have two columns with different text values:
> > Col. A
> > Product A
> > Product B
> > Product C
> > Product A
> > Product A
> > Product B
> >
> > Col. B
> > Paris - sector 1.
> > London - sector 1.
> > Rome - sector 1.
> > London - sector 2.
> > London - sector 3.
> > Paris - sector 1.
> >
> > What is the aim:
> > To count how much times product A occurs in London (also to count all
> > sections)?
> >
> > I've tried with countif and sumproduct, but no results. (((
> >
> >
> > Thank you very much for your answers and help!
> >
> > Kindly,
> > ekonomija
> >
>
>
> .
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
(((
Office