Hi,

This is my first post so I hope it is in the right forum.

I have a spreadsheet with subtotals on and we have a problem inserting new rows. I thought that when a row was inserted above the subtotal row, the subtotal would update automatically - but it doesn't.

Basically, we need to add news rows on a regular basis above the subtotal row and update the subtotal.

This is what we want to happen -

Before

2 3 4
0 2 5
2 2 0
4 7 9 (Subtotal)


After

2 3 4
0 2 5
2 2 0
0 0 2 (new row)
4 7 11 (Subtotal)

Hope this makes sense! How can we get the subtotals to update each time a new is inserted above them?

Kind regards,

Alison