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

=sumif($a$2:$a$10,a2,$b$2:$b$10)

copy down or use a pivot table, put the letter column header in the column
files and the number in the data field or sort both column ascending by
column a, then apply datasubtotal

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"david72" wrote in
message ...

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