不同單位 加總 (13952)

C2{=SUM(IF(ISERR(-B2:B9),LEFT(B2:B9,LEN(B2:B9)-1)/1%%,B2:B9))

H2{=SUM(IF(ISERR(-G2:G9),10^(FIND(RIGHT(G2:G9),"個十百千萬")-1)*ISERR(-G2:G9)*LEFT(G2:G9,LEN(G2:G9)-1),G2:G9))