summing values of duplicate entries


J

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.
 
Ad

Advertisements

Ad

Advertisements

R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top