Forum Discussion
Solved
Sumif with an AND requirement?
Hi,
I'm trying to create a document whereby I can see which products I have sold to which customer.
Attached is a basic version - the Import tab I will paste in data exported from my MRP system so I need to keep the columns in this order - the only three columns I'm interested in are the ones I have part populated already.
I then want the "All products" tab to collate this for me.
I managed to create a formula that added up the product quantity, but couldn't work out how to also have it customer specific.
Any help much appreciated - many thanks in advance.
Jamie.
- You may use a simple SUMIFS in B5, copied down rows and across columns, like this:
=SUMIFS(Import!$M:$M,
Import!$F:$F,$A5,
Import!$H:$H,B$3)
4 Replies
- You may use a simple SUMIFS in B5, copied down rows and across columns, like this:
=SUMIFS(Import!$M:$M,
Import!$F:$F,$A5,
Import!$H:$H,B$3)- You're very much welcome!
- A pivot table would make this a simple task, no formulas required.
