Summation of rows when columns change

  • Thread starter Thread starter Robert L. Salisbury
  • Start date Start date
R

Robert L. Salisbury

I enter a column of data weekly into a spread sheet and then total each row
for the last 4,8& 12 weeks. As the column numbers to be added change weekly
I have to change the formula weekly. Is there a way to do this
automatically?
 
There are numerous ways to automate the change in the Sum formula.
A little more information on how your sheet is designed will dictate the
best procedure.

Is your sum column at the beginning of the list and you add columns of data
out to columns (for example) X, Y, and Z ?
Is your sum column static, at the end of your data, and you add the weekly
data to the existing columns in between ?
Is your sum column at the end of the current data where you then *insert*
the columns of new weekly data, changing the location (address) of the sum
column ?
 
Back
Top