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!

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

"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!

do a pivot. put materials in row and weight in data field and do sum on data.

"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!

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

Thanks, I will give it a try!

"gchigo" wrote:

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

"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!

I will try your suggestion, Thank you!

"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

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

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.

thaenn wrote:

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


--

Dave Peterson