On Fri, 06 Jun 2008 09:39:03 -0400 Anthony Chilco <[EMAIL PROTECTED]> wrote:
> 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. > > Thanks, insert certainly works, but what if I want to add 400 rows, In the real spreadsheet I have I need to extend the sheet by 400 rows. Insert rows or cells would require a lot of work. Consider I have over 30 columns, about a dozen sums. I can certainly manually extend this down and change the sums. The model I have is an insurance model where the number of rows is dependent on the number of months remaining. I'm looking to partially automate this because I need to generate numbers I can check against a C++ program. -- -- Jerry Feldman <[EMAIL PROTECTED]> Boston Linux and Unix PGP key id: 537C5846 PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB CA3B 4607 4319 537C 5846
signature.asc
Description: PGP signature
