If you have a list of the unique items, you could use the SumIF formula

=Sumif(A:A,"c-130",B:B)

where "c-130" can be replaced by a cell reference to a cell containing
c-130.

If you need to meet multiple critiera, you can use Sumproduct

=SumProduct((A1:A200=D2)*(B1:B2003)*(C1:C200))

sums up values in column C where column A equals the value in D2 and column
B is greater than 3.

You also might want to look at using a PivotTable from Data=Pivot Table
Reports

This will summarize your data in the fashion you have described including
identifying the unique items.

--
Regards,
Tom Ogilvy

"Cindy Findley" wrote in message
...
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