hi claire87,
welcome to the board.....
you could do the following:
- name the range you would like to calculate the total.
- make your formula like this =sum("namedrange")
- record a macro (through Tools --> Macro --> Record Macro) and insert a row...
- at last you could add a button and apply the macro to it...
good luck!
greetz
david