本周三至上周四為時段 計總和 (14902)

H2=SUMPRODUCT(ISNUMBER(MATCH(B$2:B$21,INDEX(-MOD(ROW($1:$7)-J$2,7),WEEKDAY(F2,2))+F2+ROW($1:$7)-1,))*C$2:C$21)