加總 依各種類每行取最大 (13205)

F2{=IF(C2="合计",SUM(RIGHT(SMALL(IFERROR(OFFSET(D1:E1,,,MAX(LOOKUP(1,0/(B$2:B2<>""),ROW($1:1)-ROW(A1))))+ROW($1:$9)*10^5,),ROW($1:$9)*2),5)*1),"")