總和 單元格多名称*數量 (13450)

F5:H7=IFERROR(-LOOKUP(1,-RIGHT(MID(SUBSTITUTE($E5,"+",REPT(" ",99)),COLUMN(A1)*99-98,99),ROW($1:$99))),"")

I5:I7{=SUM(IFERROR(VLOOKUP(T(IF({1},TRIM(MID(SUBSTITUTE(SUBSTITUTE(E5,"+","*"),"*",REPT(" ",99)),COLUMN(A:E)*198-197,99)))),B:C,2,)*F5:H5,))