Array formula help across multiple tabs

Hi all,
First time poster, long time user of the site. I'm stuck with a formula and want to see if someone here can crack it. I've attached an example.

What I'm trying to do is populate a table on tab 1, summing sales figures for different markets and different weeks. The data sheet on tab 2 is the 'raw' data from which the table (tab 1) is to populate from.

I've tried a Sumif array formula, which only gets me so far (ie: I can get it to populate for 2 variables, but I'm missing part of the formula to look up the 3rd variable).

Help on this one would be greatly appreciated as I'm stumped.
Thanks,