加總 依部門與月份 (13950)

J2:L7=SUMPRODUCT(($A$2:$A$19=$I2)*(MONTH($B$1:$F$1)-LEFTB(J$1,2)=0)*$B$2:$F$19)

另解=SUMPRODUCT(($A$2:$A$19=$I2)*(MONTH($B$1:$F$1)&"月"=J$1)*$B$2:$F$19)