How to SUM using some odd criteria? SUMIFS or SUMIF will not work...

**joaolopes** · 06-17-2013, 09:16 AM

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

**TMS** · 06-17-2013, 10:24 AM

I would suggest that you use a Pivot Table.

Regards, TMS

**joaolopes** · 06-17-2013, 12:04 PM

Hi

Thanks for your reply.

This file will increase. The idea it's to be able to update the source data and update all the graphs automatically.
If I use a PT, I will need to edit it and refresh it in order to have the correct data.

Any other sugestion?

Thanks!