Tell me more ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.
up vote 1 down vote favorite

I'd like a formula for Google Docs spreadsheets that will return the sum of the values of the 10 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.

share|improve this question
2  
if you copy-paste your formula, this will "move" the formula (even if you copy it to any other cell) – JMax Feb 6 '12 at 9:56
@JMax Indeed, I realized this a while later. Thanks for the tip! – Xeon06 Feb 6 '12 at 14:56
@jmax please add that solution as an answer so Xeon06 can mark this question answered – Raystafarian Feb 13 '12 at 15:41
@Raystafarian: ok. Done :) – JMax Feb 13 '12 at 15:47

1 Answer

up vote 3 down vote accepted

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) .

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.