This is probably a very simple question, but I'm really at a loss as to what I'd search for to find this function if it exists at all.
See, I use "=AVERAGE()" as an example in one of my spreadsheets, but problem is, every month I have to change "e37" to the next up grid so, next month would be "e38", I want to be able to just do something like this: "=AVERAGE()" and have H64 retain the actual value that I want to use for that month, so "H64" would have the "38" or line value so that I only have to update one value every month.
Here is a piece of the spreadsheet hopefully it helps explains my issue.
I would suggest instead of Averaging the values at the bottom, you can try it in the first row, have a look at the following screenshot:
Formula in Cell C1: =AVERAGE(C2:C)
Formula in Cell D1: =AVERAGE(D2:D)
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.