Hi Jerry,
If you insert rows or cells from 200 down to 300, the formula will change to
reflect the new position of A200.
tc
Jerry Feldman wrote:
If I have a column of numbers, say A1 to A200 and a =SUM(A1:A200)
Now, I replicate A200 down to A300. Is there any good technique I can
set up the sum so that it will reflect this change without manually
having to change is to =SUM(A1:A300).
The actual problem I have is that I have a number of columns I need to
replicate as well as a number of different sums.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
