統計區域間 值 (14807)

F4:I4=INDEX(FREQUENCY(-$B3:$B12,-SUBSTITUTE(LEFT($F3:$H3,4),"-",)),COLUMN(A1))

F5=SUMPRODUCT(($B3:$B12>-LOOKUP(1,-LEFT(F3,ROW(1:5)))*(F3<>$I3))*$C3:$C12)-SUM($E5:E5)



留言