各單位 計算總和 (15274)

E2=ROUND(SUMPRODUCT(LEFT(SUBSTITUTE(B$2:B$9," ",REPT(" ",9)),9)*1024^(MATCH(RIGHT(B$2:B$9,2),{"KB","MB","GB"},)-1))/1024^(MATCH(D2,{"KB","MB","GB"},)-1),2)