=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