summing values of duplicate entries

[john]

Hi,
I have a spreadsheet with items listed in column A and quantities listed in
column B. Sometimes the items are listed multiple times. I would like to
create another column that will remove the duplicate entries in column A but
will sum the corresponding values in column B. Any ideas? Thanks for your
help, John.

 

[T. Valko]

To get the unique entries from column A try the advanced filter.

See this:

http://contextures.com/xladvfilter01.html#FilterUR

Then, to get the totals...

Assume the unique list starts in cell D2.

Enter this formula in E2 and copy down as needed:

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

 

[Ron Rosenfeld]

Hi,
I have a spreadsheet with items listed in column A and quantities listed in
column B. Sometimes the items are listed multiple times. I would like to
create another column that will remove the duplicate entries in column A but
will sum the corresponding values in column B. Any ideas? Thanks for your
help, John.

You could use a Pivot Table.

Drag Items to the Rows area, and Quantity to the Values (or Data) area.
--ron