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