G
Guest
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
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