On Thu, Nov 6, 2008 at 10:48 PM, Adam Victor Nazareth Brandizzi <[EMAIL PROTECTED]> wrote: > 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!
Hi, people! I was using this solution from Arnold Huzen and I note something interesting: when a cell contains text or is empty, functions like MEAN() and STDEV() ignore it. I believe it is the solution I was looking for! (I'd prefer to do not have to have a empty row, but it is acceptable :) ) Thanks again! -- Adam Victor Nazareth Brandizzi http://brandizzi.googlepages.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
