Multiple text function calculation

[ekonomija]

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

 

[Teethless mama]

=SUMPRODUCT((A2:A7="Product A")*(LEFT(B2:B7,6)="London"))

 

[Peo Sjoblom]

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



--


Regards,


Peo Sjoblom

 

[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:

 

[Teethless mama]

You're Welcome!

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:

 

[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