Running formula

W

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?
 
F

FSt1

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

Regards
FSt1
 
P

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
 
B

Bill Ridgeway

wosborne said:
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?
Click to expand...

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
 
Top