This is my first post so pardon me if I don't do this correctly! I have a spreadsheet with columns of products & columns of quantities. The quantity column has been calculated via a VLOOKUP formula.

I need a formula to then analyze the list of products and make a summary for a pick ticket. So there may be several entries of the same item in the products list but with different quantities. Is there a way to automatically sum the quantites of all the like items? Here's what it looks like:
Product Qty
c-130 2
c-130 1/2
c-110 3

I'd like to end up with c-130 2 1/2 & c-110 3. There's another section where there are 2 separate criteria plus a qty that I need to do the same thing to. Thanks for any help you can offer! - Cindy