Combine Two Formulas in Separate Cells Into One Cell

Question

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.

=SUMIFS('Inputs'!$I:$I,'Inputs'!$C:$C,$C6,'Inputs'!$D:$D,F$4)

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

Answer 1

Use the openpyxl module in Python to do that, using something like this:

import openpyxl

import os

# Change working directory
mydir = ("YOUR_PATH")
os.chdir(mydir)
    
fname = "Book1.xlsx" # the filename of the file

# Opening the workbook
wb = openpyxl.load_workbook(filename = fname, 
                            data_only = False) # False because we want formulas

ws_names = wb.sheetnames # getting the sheet names

ws = wb[ws_names[0]] # setting ws to be the first sheet

# loop over cells
for i in range(1, 9):
    
    # combine cell formulas and assign to new cell
    ws.cell(i,4).value = (ws.cell(i,2).value + 
                          " + " + 
                          ws.cell(i,3).value)[1:] # [1:] to remove the '='

# save updated workbook to new file
wb.save('NewBook.xlsx')