總和 二項 (11199)

I2=SUMPRODUCT(OFFSET(A$2,,MATCH(H2,$1:$1,)-1,28)*(A$2:A$29=I$1))

另解=SUMPRODUCT((A$2:A$99=I$1)*(B$1:F$1=H2)*B$2:F$99)