Hello,
Is it possible to get a daily ongoing total of daily values that re-starts every week? I'm using WEEKDAY() to count the days, but don't know how to SUM from the start of the week to the current (row) day/date.
Just trying to get an accumulation of hours (decimal) per week as follows
eg: (3 columns)
01/10/2021 = 5.0 = Total = 5.0
02/10/2021 = 5.5 = Total =10.5
03/10/2021 = 4.0 = Total =14.5
04/10/2021 = 8.0 = Total =22.5
05/10/2021 = 4.5 = Total =27.0
06/10/2021 = 9.5 = Total =36.5
07/10/2021 = 4.5 = Total = 41.0
08/10/2021 = 2.0 = Total = 2.0
09/10/2021 = 3.0 = Total = 5.0
10/10/2021 = 2.0 = Total = 7.0
11/10/2021 = 1.0 = Total = 8.0
12/10/2021 = 4.5 = Total = 12.5
13/10/2021 = 2.0 = Total = 14.5
14/10/2021 = 9.0 = Total = 23.5
15/10/2021 = 1.0 = Total = 1.0
16/10/2021 = 5.0 = Total = 6.0
...etc..
Without using arrays/shift-enter, etc.
The dates are not specific, and summing from the start of the week and SUM expands on each row by +1 row more.....
Bookmarks