On 2002-02-27 01:57, Anonymous wrote:

On 2002-02-27 01:35, Aladin Akyurek wrote:

On 2002-02-26 18:57, Autolycus wrote:

Why not just use :-

=SUM(A2:OFFSET(A8,-1,0))

A close reading of Lindsay's post implies that there can be additions/deletions before and after the row of formula, whence I opted for moving the formula to the top in the column of interest.

My close reading implies otherwise. Nowhere does he say that rows will be added below the formula, but rather (the capitals are mine) :-

In his first post "I have a formula that I would like to change as rows are added ABOVE it."

In his second post "If I have sum(A2:A11) in cell A12 and then I insert a row ABOVE row 12, the formula stays sum(A2:A11). If I add rows further up in the spreadsheet, the formula changes like I want, but rows are always added at the bottom, so that doesn't help me." - by "bottom" he obviously means the bottom of the rows being summed, i.e. the row immediately above the formula

## Like this thread? Share it with others