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.