Forum Discussion

Herbal_ingenuity's avatar
Herbal_ingenuity
Copper Contributor
May 24, 2023
Solved

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?

 

 

  • Herbal_ingenuity 

    You can use the SUMIF function for this:

     

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

     

    and

     

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

  • Herbal_ingenuity 

    You can use the SUMIF function for this:

     

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

     

    and

     

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

Resources