Sumif with an AND requirement?

[Jamie Sproston]

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.

[#2]

A pivot table would make this a simple task, no formulas required.

[#3 · Accepted solution]

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]

@Twifoo that's perfect !

Thank you so much, greatly appreciated.

Jamie.

[#5]

You're very much welcome!