左右各自相加與先除後加 (10901)


F3{=SUM(LEFT(C3:E3,FIND("/",C3:E3)-1)*1)&"/"&SUM(MID(C3:E3,FIND("/",C3:E3)+1,9)*1)


另解{=SUM(IMREAL(SUBSTITUTE(C3:E3,"/","-")&"i"))&"/"&SUM(MID(C3:E3,FIND("/",C3:E3)+1,9)*1)


另解{=SUBSTITUTE(SUBSTITUTE(IMSUM(SUBSTITUTE(C3:E3&"i","/","-")),"-","/"),"i",)


G3=SUMPRODUCT(("0 "&C3:E3)*1)


留言