RECEIVING SHEET & INVENTORY SHEET

Tennisbelle

I have 2 sheets. One receiving that product is received daily and one inventory sheet.

I would like to have the receiving sheet update the inventory sheet as new product arrives.

Since we get the same product on different days, I'm not sure how to account for the product and quantity to transfer to the inventory sheet and not require multipule rows.

Genevieve P.

Hey @Tennisbelle

I would use a cross-sheet formula here to SUM together all the values coming into your first, daily intake sheet like so:

=SUMIFS({Quantity Cases Column}, {Ingredient Column}, Product@row)

See: SUMIFS Function / Create cross sheet references to work with data in another sheet

Cheers,

Genevieve