隱藏部分總和 (11832)

F11:F13{=SUMIF(B$2:B$10,E11,C$2:C$10)-SUM(SUBTOTAL(109,OFFSET(C$1,ROW($1:$9),))*(B$2:B$10=E11))

另解{=SUM((SUBTOTAL(109,OFFSET(C$1,ROW($1:$9),))=0)*(B$2:B$10=E11)*C$2:C$10)