Hi

I have a spreadsheet that will have the following data:

column A Column B

AG 10
BRK 20
CH 30
AG 50
AG 40
BRK 15
BRK 70


How do I get the above to be summed on the same spreadsheet like below
eg

column A column B

AG 100
BRK 105
CH 30

Thanks for any help on this mattter


--
david72
------------------------------------------------------------------------
david72's Profile: http://www.excelforum.com/member.php...fo&userid=7980
View this thread: http://www.excelforum.com/showthread...hreadid=542755