summing data

  • Thread starter Thread starter david72
  • Start date Start date
D

david72

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
 
=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 data>subtotal

--

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
 
Back
Top