SUM all INDEX MATCHES ? (question has nice tables!!)

Hi Guys!

I feel like I'm just missing 1 step in this equation... My searches online and the forum have produced all the results that frame the boundaries of what I need, but I can't seem to put them together in one formula.

My data looks like the following table except 10 times more metric intervals than just one and is about 6000 lines long:

#	Color	January Metric	February Metric	Difference
1	Yellow	100	50	50
2	Yellow	150	75	75
3	Yellow	0	0	0
4	Yellow	5	5	0
5	Yellow	200	300	-100
6	Blue	300	300	0
7	Blue	175	0	175
8	White	16	16	0
9	White	25	25	0
10	White	80	20	60
11	White	135	135	0
12	Red	700	700	0
13	Red	0	500	-500
14	Red	20	20	0
15	Red	95	95	0
16	Red	165	165	0
17	Red	220	0	220
18	Red	310	310	0
19	Red	405	405	0
20	Red	290	290	0
21	Brown	110	110	0

And I want to make a totals table that looks like:

Color	Jan Metric Sum	Feb Metric Sum	Diff Sum
Yellow	455	430	25
Blue	475	300	175
White	256	196	60
Red	2205	2485	-280
Brown	110	110	0
Total	3501	3521	-20

My guess is that it will be some kind of

Please Login or Register  to view this content.

Please Login or Register  to view this content.

something...

Please help!

if you are able to use PowerQuery

Another options