When you say

"When I clear the contents of the cells in order to input the actual data..." which cells are you talking about ? columns D & G - in which case, don't worry; when you put in the actual data the formula will stiull work. Or did you mean cells J20 and below. In whcich case that will delete the formulae... That's not what you want to happen...