自動換列表格 右下角求和 左上角求平均 (12538)

G8{=AVERAGE(IF(ISERR(-LEFT(G6:S6,FIND(CHAR(10),G6:S6)-1)),"",LEFT(G6:S6,FIND(CHAR(10),G6:S6)-1)*1))

G9{=SUM(IFERROR(--MID(G6:S6,FIND(CHAR(10),G6:S6)+11,9),))

G8另解{=AVERAGE(IFERROR(IMREAL(SUBSTITUTE(G6:S6,CHAR(10),"+")&"i")/(G6:S6<>""),""))

G9另解{=SUM(IFERROR(IMAGINARY(SUBSTITUTE(G6:S6,CHAR(10),"+")&"i")/(G6:S6<>""),))