View Single Post
  #2   Report Post  
Abi
 
Posts: n/a
Default

Are you asking whether you need to update your total calculation each time
you add another row to your groups? If so, then no - this should
automatically happen.

"Glenn" wrote:

To create an outlined spreadsheet you do the following.

1) In cell A1, write GROUP 1
2) Select rows 2 to 9
3) From the main menu, select Data | Groups | Group
4) In cell A10, write GROUP 2
5) Select rows 11 to 19
6) From the main menu, select Data | Groups | Group

To format the cells do the following
1) In cell B1, type TOTAL 1
2) Format the cell as =SUM(A2:A9)
3) In cell B10, TOTAL 2
4) Format the cell as =SUM(A11:A19)

If I now need to add cells to my TOTAL 1, I then need
to change the format of cell B1. Can this be done
automatically somehow?