Best function to sum quantities associated with text values?

[golfretailer]

I'm trying to sum a list of products that were sold for a particular month.

My input data looks like this:

Item QTY Sold QTY Paid
Callaway Glove 2 20
Callaway Glove 1 10
Callaway Glove 6 55
Odyssey Putter 1 120
Titleist Irons 1 600
Titleist Irons 2 1000
.
.
.

I'd like my ouput to look like this:

Callaway Glove 9 85
Odyssey Putter 1 120
Titleist Irons 3 1600

Here's one of the problems...This spreadsheet is 2000 rows long, and half of the products are duplicates (although unique sales). Is there a function that will start at the top of the spreadsheet, read through the entire spreadsheet, and then summarize everything on a line-item basis? I don't have a master product list to compare against (though this exercise will provide the basis for that going forward), thus this situation requires something a little more intuitive.

Thanks for your help!

[JBeaucaire]

You can highlight the column of Item descriptions and use the Advanced Filter to create a list of [x] Unique Values only copied to another location.

Once you have that new unique list, the function you want to use to collect all the totals in one column based on matching a single value to an adjacent column is SUMIF().

=SUMIF(MatchRange, MatchValue, SumRange)

[Leith Ross]

Hello golfretailer,

The attached workbook has a button to run the macro below. This will create a summary of the stock line items on a separate sheet. Each time the macro is run, the previous summary data is deleted. The summary is sort in ascending order. Click the button and your done.

Please Login or Register  to view this content.

[DonkeyOte]

Alternatively - use a Pivot Table (see the link in sig. for general intro.)