總獎金計算 (15071)

C14:D22=SUMPRODUCT(($B$2:$B$7-MID($B14,FIND("-",$B14)+1,9)<=0)*($B$2:$B$7-LEFT($B14,FIND("-",$B14)-1)>=0)*C$2:C$7)

I2:J10=SUMPRODUCT(SUMIF($B$2:$B$7,"<="&$G2:$H2,C$2:C$7)*{-1,1})