合併格計總額與單選明細 (12990)

G3:G18 合併格公式 {=SUM(OFFSET(F3,,,-LOOKUP(1,-MATCH(1=1,B4:B$19<>"",{1,0}))))

K3:O8{=INDEX(C:C,SMALL(IF(LOOKUP(ROW($3:$18),ROW($3:$18)/($B$3:$B$18<>""),$B$3:$B$18)=$J$3,ROW($3:$18),99),ROW(A1)))&""