assuming the sum is located in a13, then name a13 as e.g. pos.
using this name, put a formula like
=SUM(INDIRECT("a1:a"&ROW(pos)-1))
in a13.

will this work for you?

keizi

"Heather" wrote in message
...
I am having trouble with a budget i have made.
I have created fromulas that are simple and just add up invoice amounts in a
total row (simple addition sum(a1:13)), the problem is that when one of my
staff need to enter a new invoice they insert a line right above the total
line and it is not included in the formula as it is now located in a14. Is
there a way to make the sum include all rows up to the formula cell?

does this make sense