H5单元格填写=IFERROR(INDEX($D$4:$D$26,MATCH(1,1*($G5=$B$4:$B$26)*(H$4=$C$4:$C$26),0)),""),并且按Ctrl+Shift+enter!
如果D列数据是数字的话H5=sumifs($D:$D,$B:$B,$G5,$C:$C,H$4)