Hi JE,

Thanks for this it worked... appreciate the help

Cheers

"JE McGimpsey" wrote:

Try:

A1: =SUM(OFFSET(A1,1,0,ROW(A4)-ROW(A1)-1,1))
A4: =SUM(OFFSET(A4,1,0,ROW(A8)-ROW(A4)-1,1))

In article ,
Andy B wrote:

hI JE,

I have tried the formula but it doesn't seem to work. I'm not sure but the
A6-1 caputures the values in cell A5. I just want the formula in A1 to
capture the amounts in A2:A3, and if someone were to add a row below the A3
row it would the new A4 the formula in A1 will read sum(A2:A4). Thereafter
the formula in the A4 cell prior to the insert would would move down.