Adding data in two columns

S

Shawn

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
 
M

Mauricio Silva

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
 
Top