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:
<tbody>
</tbody>
Data:
<tbody>
</tbody>
Table:
Week | Orders |
4/20/17 | 12 |
4/27/17 | 18 |
5/4/17 | 12 |
<tbody>
</tbody>
Data:
Item | Metric | 4/20/17 | 4/20/17 | 4/27/17 | 4/27/17 | 5/4/17 | 5/4/17 |
A | Sales | 1 | 2 | 3 | 4 | 5 | 6 |
A | Orders | 2 | 2 | 2 | 2 | 2 | 2 |
B | Sales | 1 | 2 | 3 | 4 | 5 | 6 |
B | Orders | 2 | 2 | 2 | 2 | 2 | 2 |
C | Sales | 1 | 2 | 3 | 4 | 5 | 6 |
C | Orders | 2 | 2 | 3 | 3 | 2 | 2 |
<tbody>
</tbody>