On Fri, 06 Jun 2008 09:14:50 -0400 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.
I typically in this situation adjust the SUM calculation when i first set it up to go as far as i may need it in the future. If you go through and set it to =SUM(A1:A999), then whatever the number of cells gets reasonably changed too, the formula will still work. The problem you have then only occurs when you have a change of an order of magnitude. In my situation i normally put the SUM calculation at the top of the relevant column, or on a summary sheet. -- Michael All shall be well, and all shall be well, and all manner of things shall be well - Julian of Norwich 1342 - 1416 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
