Title may be vague, let me explain. On a TI calculator, I can use variables to create an equation where var2 is used in an equation, and the answer is stored as var2. Is there a way to accomplish this in google sheets (Excel)?
IE: How can I accomplish: var1+var2= >Store: var2
What I'm trying to do in Excel is keep a running total in one cell, with an input in another cell. (I don't want an incredibly long list of inputs running down the sheet.)
What I have now just results in a cyclical #REF! error:
A1: (input)
B1: =Sum(A1+C1)
C1: =B1