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

=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

=SUMPRODUCT(--(A1:A50="Product A"),--(ISNUMBER(SEARCH("London",B1:B50))))



--


Regards,


Peo Sjoblom


"ekonomija" wrote in message
...
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

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

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

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" wrote in message
...
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



.