C3:C22=IF((COUNTIF(B$3:B3,">0")>I$3/I$7)+(B3=""),"",I$7)
G3:G22=IF((COUNTIF(C$3:C$22,">0")+COUNTIF(F$3:F3,">0")>I$3/I$7)+(F3=""),"",I$7)
一公式C3:C22=IF((SUMPRODUCT(N((0&IF({1},INDIRECT("R["&1-ROW(A1)&"]C[-4]:R["&20-ROW(A1)&"]C[-4]",)))*1>0))+COUNTIF(B$3:B3,">0")>$I$3/$I$7)+(B3=""),"",$I$7)
一公式 另解C3:C22=IF(B3>0,IF(IF(COLUMN()=7,SUM($C$3:$C$22),)+SUM(C$2:C2)=$I$3,"",$I$7),"")
C3:C22複製到G3:G22
留言
張貼留言