Why anybody wants totals at bottom?


Put them above table headers, and lock both totals and headers! And add new rows to table as much as you want.


When you want to get them at bottom for printout, create a footer, read totals into footer from totals in top of sheet, and define print area which excludes totals row at top of sheet.
(I don't remember, was there an option to print footer at last sheet. Or can you define the print area which includes 2 ranges of cells or not?)