先取計算式後 相乘加總 (14876)

N2:N4=IFERROR(VLOOKUP(LEFT(VLOOKUP(K$1,B:H,4+ROW(A1),)),L:M,2,)-IF(ISERR(FIND("-",VLOOKUP(K$1,B:H,4+ROW(A1),))),,VLOOKUP(RIGHT(VLOOKUP(K$1,B:H,4+ROW(A1),)),L:M,2,)),)

J5=SUMPRODUCT(VLOOKUP(K1,B:H,{2;3;4},)*N2:N4)