總共幾支 (11023)

D2{=SUM(IFERROR(MID(B2:B8,FIND("箱",B2:B8)-1,{1,2,3,4})*1,)*120)+SUM(IFERROR(MID(B2:B8,FIND("盒",B2:B8)-1,{1,2,3,4})*1,)*10)+SUM(IFERROR(MID(B2:B8,FIND("支",B2:B8)-1,1)*1,))