Hi,

I need to do Week to date sum figures and I was just wondering if there is a formula that you can use to move the sum down one line when you have inserted a new row.

So for example the below figures add up to seven. If I was to insert a row with the 30/09/2013 sum would add up from 30/09/2013 - 24/09/2013 and so on so forth

I hope I explained this correctly

Day Spend
23/09/2013 1
24/09/2013 1
25/09/2013 1
26/09/2013 1
27/09/2013 1
28/09/2013 1
29/09/2013 1
Total 7