Jun 29 2021 11:43 PM
I'm new to Excel and learning as I go.
I want to set up the following system:
I have $ values in columns G and H. I want to make it so that when I type a new value in a cell in G, the H cell on the same row auto-calculates the sum of the adjacent G and the above H.
So if I type a value in G4, then H4 = sum of H3+G4 and so on for each H cell whenever I add a new G value.
Jun 29 2021 11:55 PM
Jun 29 2021 11:59 PM
Jun 30 2021 12:22 AM
SolutionFormat your 2 columns as a Table where formulas format... are auto applied to new rows as they're created
Jun 30 2021 01:16 AM
Jun 30 2021 12:22 AM
SolutionFormat your 2 columns as a Table where formulas format... are auto applied to new rows as they're created