Sumif Multiple Columns with Multiple Criteria

[chicubs]

I'm trying to replicate the table below. How can I sum the total orders for each week with duplicate date values as column headers? The data is dynamic and the column dates will change, so I was wondering if it's possible to sumif the table array using date and week as criteria?

Table:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Week[/TD]
[TD]Orders[/TD]
[/TR]
[TR]
[TD]4/20/17[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]4/27/17[/TD]
[TD]18[/TD]
[/TR]
[TR]
[TD]5/4/17[/TD]
[TD]12
[/TD]
[/TR]
</tbody>[/TABLE]

Data:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Item[/TD]
[TD]Metric[/TD]
[TD]4/20/17[/TD]
[TD]4/20/17[/TD]
[TD]4/27/17[/TD]
[TD]4/27/17[/TD]
[TD]5/4/17[/TD]
[TD]5/4/17[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Sales[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Orders[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Sales[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Orders[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Sales[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Orders[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

 

[MARZIOTULLIO]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[TD]

F​

[/TD]
[TD]

G​

[/TD]
[TD]

H​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]table:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]Week[/TD]
[TD]Orders[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]

4/20/2017​

[/TD]
[TD]

12​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]

4/27/2017​

[/TD]
[TD]

14​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]

5/4/2017​

[/TD]
[TD]

12​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

7​

[/TD]
[TD]Data:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

8​

[/TD]
[TD]Item[/TD]
[TD]Metric[/TD]
[TD]

4/20/2017​

[/TD]
[TD]

4/20/2017​

[/TD]
[TD]

4/27/2017​

[/TD]
[TD]

4/27/2017​

[/TD]
[TD]

5/4/2017​

[/TD]
[TD]

5/4/2017​

[/TD]
[/TR]
[TR]
[TD]

9​

[/TD]
[TD]A[/TD]
[TD]Sales[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

3​

[/TD]
[TD]

4​

[/TD]
[TD]

5​

[/TD]
[TD]

6​

[/TD]
[/TR]
[TR]
[TD]

10​

[/TD]
[TD]A[/TD]
[TD]Orders[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

11​

[/TD]
[TD]B[/TD]
[TD]Sales[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

3​

[/TD]
[TD]

4​

[/TD]
[TD]

5​

[/TD]
[TD]

6​

[/TD]
[/TR]
[TR]
[TD]

12​

[/TD]
[TD]B[/TD]
[TD]Orders[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

13​

[/TD]
[TD]C[/TD]
[TD]Sales[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

3​

[/TD]
[TD]

4​

[/TD]
[TD]

5​

[/TD]
[TD]

6​

[/TD]
[/TR]
[TR]
[TD]

14​

[/TD]
[TD]C[/TD]
[TD]Orders[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

3​

[/TD]
[TD]

3​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[/TR]
</tbody>[/TABLE]


b3=SUMPRODUCT(($B$9:$B$14=$B$2)*($C$8:$H$8=$A3)*($C$9:$H$14)) copy dow