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 ?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum of Rows when columns are added 1
Excel Help to copy information from one row at a time to another sheet 1
How to indicate certain columns to be ignore in summation 2
"Blank" cells showing unwanted data 4
Formula to sum in columns that change weekly 1
Keep total of cells in a cell after deleting source data 8
Keeping Formula variable constant when adding new column 1
last column address 2

Back
Top