I2{=SUMPRODUCT(TEXT(RIGHT(SMALL(IF({1,0},C2,F2:F7)+ROW(1:6)*10^6,ROW(1:6)*2-1),4)-RIGHT(SMALL(IF({1,0},B2,E2:E7)+ROW(1:6)*10^6,ROW(1:6)*2),4)+1,"0;!0;0")*1)
I2另解{=SUM(TEXT(IF(F2:F7>C2,C2,F2:F7)-IF(E2:E7>B2,E2:E7,B2)+1,"0;!0;0")*1)
G2=TEXT(MIN(F2,C$2)-MAX(E2,B$2)+1,"0;!0;0")*1
G2另解=MAX(,MIN(C$2,F2)-MAX(B$2,E2)+1)
留言
張貼留言