按项目及年月份对应取值 (10871)


C4:L8=SUMPRODUCT(($D$13:$D$17=$B4)*($G$13:$G$17=INDEX($B$13:$B$17,$C$2))*(EOMONTH(IF({1},$F$13:$F$17),0)=EOMONTH(C$3,0))*$H$13:$H$17)


留言