Adding data in rows

[amax]

Thanks so much for all the help so far!

I am looking now for a (hopefully relatively simple) way to ADD (no
combine) data in cells in column b if the cells in column a match.
Example:

aaa 1
aaa 5
bbb 3
ccc 2
ccc 1
aaa 6

Would yeild:

aaa 12
bbb 3
ccc 3

Any ideas??? Many thanks

 

[Jason Morin]

The quickest way would be via a Pivot Table under the Data
menu. But you could also list all the unique cells
(assuming the list is small) from column A in cells F1:F3,
then use this G1 and copy down:

=SUMIF(A:A,F1,B:B)

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Hi
in addition to Jason's answer you could also use pivot tables for this
task. See the following for more information:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm

Frank