Excel YTD total
Posted on 2003-02-27
I have a spreadsheet that has 26 columns with a weeking ending date at the top of each.
In the rows below I have data that is pulled in by query on a weekly basis. I have a total column before all these columns that I keep a running sum total of values. I think there is an easier way to update that total column. Right now, I find and replace the column value in my sum formula and increment it to the new column.
Can I update based on the today() to change the formula?
Total 1/4 1/11 1/18 1/25 2/1 2/8 2/15 2/22 etc
50 10 5 5 20 0 0 10
60 10 10 10 10 0 10 10