單位不同 計算總合 (15291)

E2{=SUM(MID(SMALL(IFERROR(MID(B$2:B$9,1,COLUMN($A:$I))*1,)+ROW(1:8)*10^8,ROW($1:$8)*9),2,99)*IF(ISNUMBER(FIND("Kg",B$2:B$9)),1000,IF(ISNUMBER(FIND("噸",B$2:B$9)),10^6,1)))/1000^(MATCH(D2,{"g","Kg","噸"},)-1)