日常分类求支付的和 (8896)

I2:G16{=SUM(MMULT($D$2:$F$16*1,{1;1;1})*($C$2:$C$16=$H2)*($B$2:$B$16=I$1))

另解{=SUM(SUMIFS(OFFSET($D:$D,,{0,1,2}),$B:$B,I$1,$C:$C,$H2))

另解=SUM(SUMIFS(INDIRECT({"D:D","E:E","F:F"}),$B:$B,I$1,$C:$C,$H2))