That was the answer, Thanks Dave!

"Dave Peterson" wrote:

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.





thaenn wrote:

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!

--

Dave Peterson