Take the tour ×  I have a spreadsheet with 3 columns:
Subtotal, for example, is 1000 to start, like:  |      |      |
1000     |  Then I want to be able to add an item like:  |
|      | 1000     | | item | 50   |          |  I want subtotal
to update now.  I know I can do:   But I want it to be dynamic
like:   Where BX is this B and CX is this C -1 row (the row
above the current one to subtract one)  How an I do this with
GDocs?  share|improve this question add comment  migrated from
superuser.com Feb 2 '11 at 18:38   1 Answer  Simply copy your
formula from that cell to each cell below. Copying formulas with
relative references (those without $) adjusts them
automatically.  I think you have your coordinates backwards,
though. Cell C2 contains "1000" and cell B3 contains "50", so
your formula in C3 should be =MINUS(C2,B3) (or =C2-B3).
share|improve this answer Oops, yes, it is backwards! How do I
make "relative" refs and not absolute ones? –  Oscar Godson Feb
1 '11 at 19:54 Nevermind! Yes this is easy,