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
Bookmarks