I'd like a formula for Google Sheets that will return the sum of the values of the ten cells above the current cell.
That is, if I'm on C31, I want the equivalent of =SUM(C20:C30). However, I want something that will work independently of the current cell.
Best Answer
As discussed in the comments, if you copy-paste your formula, this will "move" the formula (even if you copy it to any other cell).
This is the same behavior as Excel. Note that you can use the
$too to keep either the column (=$A1) or the row (=A$1) or both (=$A$1) .