Adding data in rows

  • Thread starter Thread starter amax
  • Start date Start date
A

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