Hi Adam, If you add the row between b7 and b8, then the formula will update the range. If you plan to add rows, set up the sum with an empty row at the bottom and include it in the sum range. Adding rows above the empty row will cause the formula range to change. tc
> Date: Thu, 6 Nov 2008 18:12:53 -0200 > From: [EMAIL PROTECTED] > To: [email protected] > Subject: [users] Updating ranges after inserting line > > Hi, people! > > I have a spreadsheet with a list of values, let's say, at the interval > B2:B8. At B9, I have the formula =SUM(B2:B8). If I insert a new row > between B8 and B9, the formula at the now B10 cell is not updated. > > Is there a simple way to make this formula automatically update > itself? I'm leaving a blank row between the last value and the sum > cell; I believe I could do some black magic with info functions and > such; also, I know I could use macros, but I'm looking for something > easier, since I'm going to teach it. > > Thanks in advance! > > -- > Adam Victor Nazareth Brandizzi > http://brandizzi.googlepages.com/ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > _________________________________________________________________
