Multiple text function calculation
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
|