區間總和與取區間日 (14933)

(取區間日)D12:H12{=IFERROR(DAY(IFERROR(INDEX(8:8,SMALL(IF($E10:$P10="是",COLUMN($E:$P)),COLUMN(A1)-1)+1),$E8))&"-"&DAY(INDEX(8:8,SMALL(IF($E10:$P10="是",COLUMN($E:$P)),COLUMN(A1))))&"日","")

(區間總和)D13:H13=IF(D12="","",SUMPRODUCT((DAY($E8:$P8)-LEFT(D12,FIND("-",D12)-1)>=0)*(DAY($E8:$P8)-MIDB(D12,FIND("-",D12)+1,2)<=0)*$E9:$P9))