Auto-sum a range

[James]

i know that Excel will not assume that a new column at the edge of a range
is to be added into the range to be summed. is there anyway to work around
this?
i want to sum A1-G1 and have the total in H1. however, i may need to insert
a column after G1. and have that new column (which would now be H1) added to
the total. any ideas?

 

[Jason Morin]

Try this in H1:

=SUM(OFFSET(INDIRECT("RC",0),,-1,,-COLUMN()+1))

HTH
Jason
Atlanta, GA

 

[Domenic]

Hi James,

Try the following formula in H1:

=SUM($A1:OFFSET(H1,,-1))

Hope this helps!

 

[James]

this worked great once i figured out to hit CTRL-ENTER after pasting this
into the spreadsheet!
thanks guys... AGAIN!
;-)