Adding data in two columns

[Guest]

Help!

I am working with data in two columns and would like to total the dupilcate
numbers giving me a sum total.

Example:
Column A Column B
12345 4
12345 2
12345 6

I would like to combine all into one line that would look like:
Column A Column B
12345 12

Any suggestions would be greatly appeciated!!
Shawn

 

[Frank Kabel]

Hi
use a pivot table for this. 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

 

[Guest]

If you have a limited and known number of values in Column A, you could use
SumIF

=SumIf(A1:A3, 123, "B1:B3)

Mauricio Silva

 

[Myrna Larson]

In addition to the other suggestions, you might look at Data/Consolidation.