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.
You could use something like =SUM(A1:A65000) as long as the summation
cell was not located in column A.
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
