Hi

Thanks for your time.

I've a problem...

Assume this data:

Person Product Price
1 A 10€
2 A 20€
1 B 30€
3 A 40€
4 A 50€
5 A 60€
1 A 70€
6 B 80€

I need to know how much did I sell (SUM Price column) from product B from people that have also bought Product A.

For example, the price total of people that bought B and also A it's 30€ (the Person 6 didn't bought A).
The total sum of product A from people that bought also B it's 10€+70€=80€

Can someone help me in this?
I must also use this formula for more Products. Not only A and B.

Thanks for your time!

Best regards!

João Lopes