I have data in Column A that repeats in groups; AAA, BBB, CCC, etc. Each of
these column A values is associated with a varible in column B. I want to
break at the end of a group and sum the column B.



Here's what I have and what I need.


What I have:


AAA 111
AAA 222
AAA 111
BBB 444
BBB 222
BBB 111
BBB 111
CCC 444
DDD 222
DDD 666


Here's what I want -- the break and the summation of Column B

AAA 111
AAA 222
AAA 111
444 (Sum of AAA)

BBB 444
BBB 222
BBB 111
BBB 111
888 (Sum of BBB)

CCC 444
444 (Sum of CCC)

DDD 222
DDD 666
888 (Sum of DDD)



I appreciate anything you can do to help.