Hi Guys
I am trying to sort some data on production for a factory.
I am trying to work out production per kg based on amount produced. the problem is that sometimes production for the raw material runs over to the next day.
At the moment i am adding up the total produced from the material and dividing it by the raw material.
That looks like this.
To find actual prod F15, I then added up the values in D14 & D15 then in F15 I inputed the total. I have the correct answers but I need the staff to be able to input the info and have the formula pre existing to save time. is this at all possible?
Here is my sheet as I don't think even i can follow my ramblings.
Help.xlsx
Thanks in advance for the help.
Bookmarks