close
Anyone?Here is one far out, impractical solution:
Add a helper column (Seq), so your data looks like this:
SeqMon
11
28
35
46
53
68
71
83
97
104
Tue
Name the Seq, Mon and Tue ranges.
The sum for Mon is this array formula
=SUM((Seqlt;=MAX(ROW(Mon)-ROW(INDEX(Seq,1)) 1))*Mon:Tue)
For Tue:
=SUM((Seqgt;MAX(ROW(Mon)-ROW(INDEX(Seq,1)) 1))*
(Seqlt;=MAX(ROW(Tue)-ROW(INDEX(Seq,1)) 1))*Mon:Tue)
The data may be sorted without affecting the results if
Seq is included in the sort.
全站熱搜
留言列表
