銷售區域分布 (14775)

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

F5:I5=SUMPRODUCT((LEFT(F3,4)*(F3<>$I3)-$B3:$B12<0)*$C3:$C12)-SUM($E5:E5)