lazarandreiflorin
New Member
- Joined
- Dec 16, 2018
- Messages
- 34
I want to create a spreadsheet for stock keeping for a grain silo plant. I have come up with something, I will attach it.
What formula should I use so that the quantity in row C7:J7 updates automatically when the operators type in processes like in the example based on the criteria for type of product, client and bin number and also based on the type of process. For intake the quantity should be added and for outtake it should be subtracted. In the attached photo I put in as example two processes and after that the quantity for bin C1 should show 750.
Hope I made myself clear. English is not my first language.
Thank you in advance
What formula should I use so that the quantity in row C7:J7 updates automatically when the operators type in processes like in the example based on the criteria for type of product, client and bin number and also based on the type of process. For intake the quantity should be added and for outtake it should be subtracted. In the attached photo I put in as example two processes and after that the quantity for bin C1 should show 750.
Hope I made myself clear. English is not my first language.
Thank you in advance
