加總 依日期指定範圍 (14583)

G2=SUMPRODUCT((C$2:C$10>=F2-IF(RIGHT(F2,2)-15=0,14,9))*(C$2:C$10<=F2)*D$2:D$10*B$2:B$10)

另解{=SUM(SUMIFS(B:B,D:D,1,C:C,LEFT(F2,6)/1%+IF(--RIGHT(F2,2)=15,ROW($1:$15),ROW($16:$25))))

另解=SUMPRODUCT(SUMIFS(B:B,D:D,1,C:C,"<="&F2-IF(RIGHT(F2,2)="15",{15;0},{10;0}))*{-1;1})

另解=SUMIFS(B:B,D:D,1,C:C,">="&F2-9-5*(RIGHT(F2,2)="15"),C:C,"<="&F2)