automatically adjust sum to include top row (added)

[JR]

I used to know how to this, but can not remember.

I have a worksheet where a row is added to the top of a list of rows when a
macro is run.
There is a sum row at the bottom of the list of rows.

How do I set it up so that the newly added row is included in the sum?

Thanks!

 

[T. Valko]

Try this...

Let's assume your current formula looks like this:

=SUM(A1:A10)

Use this:

=SUM(INDIRECT("A1"):A10)

 

[Bob Ryan]

I usually include the heading row in my sum.