Running formula

[wosborne]

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?

 

[FSt1]

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

Regards
FSt1

 

[Pete_UK]

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

 

[wosborne]

=SUM(K1:K128)

I am just using the basic sum formula

 

[Bill Ridgeway]

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><Define>Type 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