How to calculate the cummulative sum of values between 2 dates in expression ?

[#1]

I want capture the cummulative sum of say Passed values between 2 dates (where one is in dimension) in expression

For eg: day 1: sum(passed) w.r.t latest excecuted time

day2: sum of passed for day 1 as well as day2 w.r.t latest excecuted time

day3: sum of passed of day1, day 2, day3 w.r.t latest excecuted time

In aggregation I want give inbetween function of those 2 dates

Sample: Input data

test case	1.4		2.4	3.4	4.4		5.4	6.4	7.4
a	passed		passed	failed	passed				failed	passed
b			passed				failed		failed	passed
c		passed	failed		passed	passed			passed	failed
d	passed							skipped
e			failed	failed	passed	passed		failed
f	skipped				passed	passed
g	passed

Required Output:

Day	passed	failed	skipped
7.4	4	2	1
6.4	4	2	1
5.4	6		1
4.4	7
3.4	3	3	1
2.4	4	2	1
1.4	4		1

[MK_QSL]

Can you please provide your sample data in excel file?

[#3]

try using rangesum()