排每生產量 扣除周日 節日 (14848)

I4:AJ5=IF((MEDIAN(I$3,$E4:$F4)=I$3)*IF($H4>0,MEDIAN(I$3,TEXT({1;-1}%,SUBSTITUTE(SUBSTITUTE($H4,".","/"),"-",";"))*1)<>I$3,1)*(I$2<>"日"),MIN($C4-SUM($H4:H4),$D4),"")

另解=MIN($D4,$C4-SUM($H4:H4))*IF($H4>0,(MEDIAN(--TRIM(SUBSTITUTE(MID(SUBSTITUTE($H4,"-","   "),{1,6},6),".","/")),I$3)<>I$3),1)*(MEDIAN($E4:$F4,I$3)=I$3)*(I$2<>"日")