ldiaz,

Select your table, and then use Data / Pivot Table and drop the product name into the row, and the
count into the data area. Change the field setting to SUM and you're done.

HTH,
Bernie
MS Excel MVP


"ldiaz" wrote in message
...
Hi all comunity.

I have this probelm:

I have an inventory in Excel with many (maybe 1000) products, like this
table show, but some product are in different location , what I want is to
sum total of qty by product in another sheet putting a link with a formula,
but his need to sum for example:

Tomatoes should be a total of: 10
Apple should be a total of: 25 summing Location A2 and A5
Pear should be a total of: 38 summing Location A1,A6 and A9




Location Product Qty
A1 Tomatoes 10
A1 Pear 18
A2 Apple 10
A4 Banana 15
A5 Apple 15
A6 Pear 10
A9 Pear 10

anybody can help me, it will be great..

Thank you

ldiaz