使用2021/365版本F15:=SORT(UNIQUE(J3:J11))向下複製公式。G15:=INDEX($I$3:$I$13,MATCH(F15,$J$3:$J$11,0))向下複製公式。H15:=SUM(IF($J$3:$J$11=F15,$F$3:$F$11,0))向下複製公式。I15:=SUM(IF($J$3:$J$11=F15,$G$3:$G$11,""))向下複製公式。J15:=H15+I15向下複製公式。K15:=SUMIF($F$15:$F$20,LEFT(F15,2)&"*",$H$15:$H$20)K17:=SUMIF($F$15:$F$20,LEFT(F17,2)&"*",$H$15:$H$20)K18:=SUMIF($F$15:$F$20,LEFT(F18,2)&"*",$H$15:$H$20)K20:=SUMIF($F$15:$F$20,LEFT(F20,2)&"*",$H$15:$H$20)