software

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 70How 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: www.excelforum.com/member.php...foamp;userid=7980
View this thread: 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 datagt;subtotal

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;david72quot; gt; wrote in
message ...
gt;
gt; Hi
gt;
gt; I have a spreadsheet that will have the following data:
gt;
gt; column A Column B
gt;
gt; AG 10
gt; BRK 20
gt; CH 30
gt; AG 50
gt; AG 40
gt; BRK 15
gt; BRK 70
gt;
gt;
gt; How do I get the above to be summed on the same spreadsheet like below
gt; eg
gt;
gt; column A column B
gt;
gt; AG 100
gt; BRK 105
gt; CH 30
gt;
gt; Thanks for any help on this mattter
gt;
gt;
gt; --
gt; david72
gt; ------------------------------------------------------------------------
gt; david72's Profile:
gt; www.excelforum.com/member.php...foamp;userid=7980
gt; View this thread: www.excelforum.com/showthread...hreadid=542755
gt;