title: Locking formula values in google sheets
body: <h2>Question</h2>
  <p>I'm trying to make a google sheet for calculating my net income over a set period of time. I have all the things but one thing figured out. That one thing being, I don't know how to lock a value in a formula to make it say the same for when I select and copy the cell formula to other cells. I've tried googling but all I can find is stuff about how to lock a cell to keep it from being edited, so I don't know if this is a thing that can be done. I'm very new to google sheets (and any form of sheets) so I don't have much idea as to what I'm doing. Thus far in my journey google has been able to help me greatly, but now that I've exhausted all other resources, I figured it couldn't hurt to ask you guys. Some help would be greatly appreciated, Thanks in advance. If my question wasn't very clear or needs rewording please let me know and I will work to correct whatever it is that is unclear.</p>
  <h2>Link</h2>
  <hr> 
  (this isn't the actual form I'm using, this is just a scratch form that you guys can type formulas into and leave comments on)
  <pre><code>    https://docs.google.com/spreadsheets/d/1at6TT3HAcMNswNL0rZqLeScTBEEiCff2fGgbT3vxHK0/edit?usp=sharing
  </code></pre>
  <h2>Edit</h2>
  <hr> 
  So I've been doing some searching and working on the sheet, and I've decided to drop one of the things I was going to do because it didn't make much sense. So now the situation is that I need to have a value *change dynamically* as I continue to add more rows. What I'm trying to do now is have the cell formula change to add together the cell, say B3, and the cell above it, B2, and have that stored on another cell. I don't really know how to go about doing this, so any help or advice is greatly appreciated. Thanks in advance and sorry for the sudden change.