Adam Victor Nazareth Brandizzi wrote:
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!
Another solution: Put your summation at the top row. Then just add new
data to the first empty row at the bottom. The summation formula would
look something like =SUM(A2:A65536)
and then you never have to worry about inserting.
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
