combine info in spreadsheet

[Jyl]

I'm trying to combine some info that looks like:
A B C
amount name accountname
100 joe account1
150 joe account1
130 joe account1
110 joe account2
125 joe account2
150 jon account3
150 jon account3
150 tom account4
150 tom account4
150 tom account4

I would like to combine the data by account name,
totalling the amounts but still showing who it belongs to
in column b. Any ideas. Thanks in advance.

 

[Frank Kabel]

Hi
use a pivot table. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm