Formula to sumif a column and all corresponding values in a table, if it matches a condition/s in another table

[tyrese215]

Table 1
Metric1 (Unique)	Jan-17	Feb-17	Mar-17	Apr-17	May-17	Jun-17	Jul-17
A
B
C
D
E
F
Table 2
Metric1	Month	Metric2
A	Jan-17	166
A	Apr-17	129
B	Jan-17	215
C	Apr-17	136
B	Mar-17	506
A	Feb-17	209
A	Feb-17	191
E	Mar-17	427
E	Jun-17	253
F	Jan-17	469
B	Jul-17	495
B	Jan-17	168
C	Jul-17	553
C	Jan-17	161
C	Apr-17	244
A	Mar-17	154
A	Feb-17	291
A	Mar-17	518
A	Mar-17	529
A	Mar-17	158
A	Feb-17	421
A	Feb-17	361

<tbody>
</tbody><colgroup><col><col span="7"></colgroup>

In table 2 above I have multiple instances of the same “Metric1”. Beside this column I have the month that this metric relates too, and the value of the metric in column C. This table 2 would be a dynamic dataset that will expand in terms of the number of rows.

I want to summarize this Table 2 into a Table 1 view.

In table 1, I have unique instances of all Metric1, and the months going across row 2. I need a dynamic formula I can place in all the green cells that will Sumif all metric1, and place the total if it matches the date in row 2 above.

Thank you heaps

 

[alansidman]

To get this, I created a simple Pivot Table.

Data Range

	A​	B​	C​	D​	E​	F​	G​	H​
1​
2​
3​	Sum of Metric2​	Column Labels​
4​	Row Labels​	1/17/18​	2/17/18​	3/17/18​	4/17/18​	6/17/18​	7/17/18​	Grand Total​
5​	A​	166​	1473​	1359​	129​			3127​
6​	B​	383​		506​			495​	1384​
7​	C​	161​			380​		553​	1094​
8​	E​			427​		253​		680​
9​	F​	469​						469​
10​	Grand Total​	1179​	1473​	2292​	509​	253​	1048​	6754​

<tbody>
</tbody>

Pivot Tables are on the Insert Tab of the Ribbon. Metric 1 as Rows, Months as Columns, Metric 2 as Values.