如题所述
B8公式右拉下拉:
=SUMPRODUCT((MONTH($C$2:$C$5)=--SUBSTITUTE(B$7,"月",))*($D$2:$D$5=$A8)*$E$2:$E$5)
H8公式右拉下拉:
=SUMPRODUCT((MONTH($C$2:$C$5)=--SUBSTITUTE(H$7,"月",))*($D$2:$D$5=$A8)*$G$2:$G$5)