I am trying to automatically compare sum of week-to-date v. previous week-to-date

  • Thread starter Thread starter twister212atop
  • Start date Start date
T

twister212atop

I am trying to automatically compare sum of week-to-date data v.
previous week-to-date data after entering daily stats. Any ideas would
be much appreciated. Thanks!
 
Hi
you may provide some more details about your data layout. e.g. post
some sample data
 
Ok, here goes:

Col a=dates, 1 day increment for 1 year
Col b=data, lets say three-digit integers
Col c=data2
Col d=data3

Each day an additional integer is entered into the row that corresponds
to the appropriate date

I want a summary sheet with data items down the rows and various sums
along the top:

Week-to-Date (WTD) Sum Previous WTD Sum WTD Avg
Prv WTD Avg
Data
Data2
Data3

Summary sheet should update automatically when the today date is
updated and new data is entered.

Thanks!
 
Back
Top