Forum Discussion
Herbal_ingenuity
May 24, 2023Copper Contributor
Count and transfer
I have a spreadsheet. On Tab 1 "BULK", I enter in an item #, Item tag weight, and item actual weight.
For the same product there can be multiple item #s.
On Tab 2 "SUMMARY", I combine each item # and manually transfer over the tag and actual weights.
Is there a way to automatically transfer over and count. So if there are 6 item #123 cells, it would transfer over from "BULK" to "SUMMARY" to 1 cell and total the tag and actual weights for item #123?
You can use the SUMIF function for this:
=SUMIF(Sheet1!ItemRange, Item, Sheet1!TabRange)
and
=SUMIF(Sheet1!ItemRange, Item, Sheet1!WeightRange)
You can use the SUMIF function for this:
=SUMIF(Sheet1!ItemRange, Item, Sheet1!TabRange)
and
=SUMIF(Sheet1!ItemRange, Item, Sheet1!WeightRange)