SOLVED

Automated calculation

Copper Contributor

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.

5 Replies

@AtomBacon 

 

Demo.png

in H4 and copy down as necessary

=SUM(H3) + G4
Is there something I can use (like a formula I can type in the H header) that will automate that process rather than having to copy paste for every cell?
best response confirmed by AtomBacon (Copper Contributor)
Solution

@AtomBacon 

Format your 2 columns as a Table where formulas format... are auto applied to new rows as they're created

Thank you.
You're welcome. Somewhere on each reply there's an option to mark as best response => Can help others...
1 best response

Accepted Solutions
best response confirmed by AtomBacon (Copper Contributor)
Solution

@AtomBacon 

Format your 2 columns as a Table where formulas format... are auto applied to new rows as they're created

View solution in original post