Help with Formula to Sum Product Sales based on Sales Channel and Product

I've been asked to provide a weekly report to a non technical person with limited excel experience, the report simply needs to contain a table of product sales by each individual channel.

My reporting software has limitations and I can only export one order per line. My problem is I don't know how to sum the quantity of each product line based on channel.

The principal of the sum should be as follows...

Add the numerical value in the Quantity Column IF SubSource = 'X' AND SKU = 'Y'

My aim is to set the Print Area over the results, print them off, and pass it on to the relevant person.


Casehype_Sales_Report_Example.xlsx

Hi
Use

Formula:

Please Login or Register  to view this content.

in G2 and copy to G2:I9

Hi José

I'm no longer at the office so don't have access to the full file but I've tested it on the sample and it seems to have worked perfectly.

Many thanks!