I have a spreadsheet that count and adds the numbers in one column. My only
problem is that I am constantly adding and taking away rows. Is there a way
that I can get my formula to automatically update without having to manually
change the formula everytime?

hi
if you are using relative references in your formula, it should adjust
automaticly.
post your formula.

Regards
FSt1

"wosborne" wrote:

I have a spreadsheet that count and adds the numbers in one column. My only
problem is that I am constantly adding and taking away rows. Is there a way
that I can get my formula to automatically update without having to manually
change the formula everytime?

Make the range references large enough to accommodate your additions/
deletions, and position the formulae where it will not get deleted.
For example, put:

=SUM(A2:A2000)

in A1 to add numbers in that column, even if you only have 50 numbers
to sum.

Hope this helps.

Pete

On Oct 2, 4:46*pm, wosborne
wrote:
I have a spreadsheet that count and adds the numbers in one column. My only
problem is that I am constantly adding and taking away rows. Is there a way
that I can get my formula to automatically update without having to manually
change the formula everytime?

=SUM(K1:K128)

I am just using the basic sum formula

"FSt1" wrote:

hi
if you are using relative references in your formula, it should adjust
automaticly.
post your formula.

Regards
FSt1

"wosborne" wrote:

I have a spreadsheet that count and adds the numbers in one column. My only
problem is that I am constantly adding and taking away rows. Is there a way
that I can get my formula to automatically update without having to manually
change the formula everytime?

"wosborne" wrote in message
...
I have a spreadsheet that count and adds the numbers in one column. My only
problem is that I am constantly adding and taking away rows. Is there a
way
that I can get my formula to automatically update without having to
manually
change the formula everytime?

I suggest you fix the cell reference so it will refer to a particular cell
wherever it is. To do this click on <Insert<Name<DefineType in a short
name (but not something which may be mistaken for a cell reference) and
click on <OK. When you refer to this cell in a formula it will take the
name of and refer to the cell (wherever it is) not the cell reference.

Regards.

Bill Ridgeway
Computer Solutions