I handle this problem by filling the empty row with dashes or equal signs to remind me that the row is a non-data row. Then I name the range from the head of the column to the dashed line based on the type of data in the column (e.g., "Miles") and then make the formula in the sum line =SUM(Miles). When I need to add a new row of data, I just add the row above the dashed line and the named range automatically updates itself.
I hope this helps. On Thu, Nov 6, 2008 at 3:12 PM, Adam Victor Nazareth Brandizzi < [EMAIL PROTECTED]> wrote: > 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] > >
