[Solved] Copy formula with negative increment

[Aduxas]

cell A1 has function =B31+C31. How can I copy this formula down with a negative increment? I.e.:
cell A2 has function =B30+C30
cell A3 has function =B29+C29 etc.

It does work with data: A1 has value 10; A2 has value 9. If I select both cells and use the fill handle, I can generate a descending series in column A. This does not work with formulae. Any suggestions?

[gerard24]

in A1 :

Code: Select all

=SUM(OFFSET($B$32;-ROW(A1);0;1;2))

[Aduxas]

Thanks for the reply. Good workaround.