Lord willing, we will still be here when you get ready to pick this back up, so don't worry about that.
If you have some time while waiting to be discharged you might consider a couple of things.
1. Would it be feasible to put the result of the formula from post #5 in a cell and let your real world formula reference that cell in the two or three places rather than inserting the formula from post #5 two or three times?
2. If not, is there a way to post a small desensitized version of your real world workbook, so that we could see if there is a better solution?
All the best.