Thanks all for the responses! On Thu, Nov 6, 2008 at 8:43 PM, John & Mary Linge <[EMAIL PROTECTED]> wrote: > 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.
Yes, I actually > 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] >> >> > -- Adam Victor Nazareth Brandizzi http://brandizzi.googlepages.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]