Count and transfer

[Herbal_ingenuity]

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?

[#2 · Accepted solution]

@Herbal_ingenuity 

You can use the SUMIF function for this:

=SUMIF(Sheet1!ItemRange, Item, Sheet1!TabRange)

and

=SUMIF(Sheet1!ItemRange, Item, Sheet1!WeightRange)