automatically adjust sum to include top row (added)

  • Thread starter Thread starter JR
  • Start date Start date
J

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!
 
Try this...

Let's assume your current formula looks like this:

=SUM(A1:A10)

Use this:

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