Understaing Consolidating

[Mstg007]

I am trying to better understand how to do this properly. I am starting with a basic list to get a better idea how to do this.

Column A Column B
Red 10
Red 12
Blue 21
Green 51
Red 70
Green 101
Blue 2
Yellow 1

How can I total in a list form for:
Red 92
Blue 23
Green 152
Yellow 1


I hope this makes some sense to what I am trying to do.

 

[JoeMo]

Copy E2 down:

Excel Workbook
	A	B	C	D	E
1	Color	Value		Color	TotValue
2	Red	10		Red	92
3	Red	12		Blue	23
4	Blue	21		Green	152
5	Green	51		Yellow	1
6	Red	70
7	Green	101
8	Blue	2
9	Yellow	1
Sheet2

 

[Mstg007]

Thank you for your help! Makes sense.