Comparison of data in two separate colunms

T

thaenn

In "Column AW" I have a list of material items (there are some that are the
same), and in "Column AX" I have the weight associated with each item.

My question is: How can I look up all "like items" in column AW and get a
total of the combined weight (for these like items)?

Thanks!
 
G

gchigo

use pivot table. add materials to row and weight to data and do a sum
function on the data.
 
D

Dave Peterson

For any one particular item (say Item1):
=sumif(aw:aw,"item1",ax:ax)

If you have lots of these items, you may want to look at data|pivottables.
 
T

thaenn

I will try your suggestion, Thank you!

Dave Peterson said:
For any one particular item (say Item1):
=sumif(aw:aw,"item1",ax:ax)

If you have lots of these items, you may want to look at data|pivottables.
Click to expand...
 
T

thaenn

That was the answer, Thanks Dave!

Dave Peterson said:
For any one particular item (say Item1):
=sumif(aw:aw,"item1",ax:ax)

If you have lots of these items, you may want to look at data|pivottables.
Click to expand...
 
D

Dave Peterson

One more way.

Sort your data by column AW.
Then apply data|subtotals and subtotal using sum the values in column AX--based
on the key in column AW.

You can use the outlining symbols to the left to hide/show the details.
 
Top