Hi Everyone,
I am trying to find a formula to calculate inventory for my end of month counts. Sheet #4 will calculate all items into certain columns that will add up each item and deduct that from the total deliveries. Is this possible?
Sheet 1 total deliveries
Sheet 2 total items sold
Sheet 3 ending inventory
Sheet 4 recipes
So sheet 4 will have recipes for exampleI s
bundle 1: whole chicken, box #4, large rice, box #2, chowder
bundle 2: whole chicken, box #4, large rice, box #2, stew
half chicken, box #2, regular rice, box #2
noodles, box #2
Thank you in advance.
I am trying to find a formula to calculate inventory for my end of month counts. Sheet #4 will calculate all items into certain columns that will add up each item and deduct that from the total deliveries. Is this possible?
Sheet 1 total deliveries
Sheet 2 total items sold
Sheet 3 ending inventory
Sheet 4 recipes
So sheet 4 will have recipes for exampleI s
bundle 1: whole chicken, box #4, large rice, box #2, chowder
bundle 2: whole chicken, box #4, large rice, box #2, stew
half chicken, box #2, regular rice, box #2
noodles, box #2
Thank you in advance.