Thanks all for the responses! On Thu, Nov 6, 2008 at 6:41 PM, Arnold Huzen <[EMAIL PROTECTED]> wrote: > I usually keep an empty row or column between the data and the cell > containing the formula if I expect that I wil insert rows or columns in the > future. In the formula I include the empty cell. If I then need to insert a > new cell in the range it will also extend the formula. > > In your example I would have the data in B2:B8, leave B9 blank and put the > formula =SUM(B2:B9) in B10. > > As you do this you must keep in mind what the formula does that you use. In > the above example it works just fine, because an empty cell makes no > difference to the result. But in other functions that might be different.
Yes, I do it, too. The great problem is exatly other functions, like MEAN(). I'd like to do not need to do it. Well, if there is no such thing, I'll have to deal with the workaround :) Again, thanks you all! > Arnold Huzen > > > Adam Victor Nazareth Brandizzi schreef: >> >> 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! >> > > --------------------------------------------------------------------- > 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]
