I have 850 cells in Excel and have been asked to consolidate two calculations into one cell. If one cell is referencing a certain cell in another worksheet, such as ='Acquisition'! G32 and the alternate formula look like this.
The goal is to have one formula like
='Acquisition'!G32 + SUMIFS('Inputs'!$I:$I,'Inputs'!$C:$C,$C6,'Inputs'!$D:$D,F$4)
Can I develop some code or an Excel function to accomplish this? As the references are to highly particular cells, I am unable to drag my formulas once throughout my range of cells.
I have attempted a number of Excel functions, including Cell, Concatenate, Offset, and a few others, but I am unable to combine the formulas into a single cell. Each formula's output can only be entered into one cell.
The goal is to go from: =formula1 = formula2 -> =formula1 + formula2