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!