年度後面數字 加總 (14091)

D3:H6{=TEXT(SUM(IFERROR(MID(SUBSTITUTE(LEFT(MID($A3,FIND(D$2&"-",$A3)+5,99),FIND("-",MID($A3,FIND(D$2&"-",$A3)+5,99)&",,,,,-")-6),",",REPT(" ",29)),ROW($1:$9)*29-28,29)*1,)),"0;;")



留言