區間值 取出 (10896)

A2   1500後 + "-"=SUMPRODUCT(FREQUENCY(-H2,-LEFT(A$2:A$8,FIND("-",A$2:A$8)-1))*B$2:B$9)*H2

另解A2   1500後 無須 + "-"=H2*LOOKUP(,0/FREQUENCY(-H2,-TEXT(,"[$"&SUBSTITUTE(A$2:A$8,"及以上","-")&"]")),B$2:B$8)