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]
