F2{=ROUND(SUM(IFERROR(LEFT(B$2:B16,LEN(B$2:B16)-3)*1024^(MATCH(RIGHT(B$2:B16,2),{"KB","MB","GB"},)-1),))/1024^(MATCH(E2,{"KB","MB","GB"},)-1),2)
C2=IFERROR(SUM(LEFT(B2,LEN(B2)-3)*1024^(MATCH(RIGHT(B2,2),{"KB","MB","GB"},)-1)),)
G2=ROUND(SUM(C:C)/1024^(ROW(A1)-1),2)
留言
張貼留言