excel、WPS工作表里面的"=SUMPRODUCT(出库明细!$B:$B,1*(OFFSET(出库明细!$B:$B,0,SUM(COLUMN(出库明细!$C:$C)-COLUMN(出库明细!$B:$B)))=$A4)*(OFFSET(出库明细!$B:$B,0,SUM(COLUMN(出库明细!$D:$D)-COLUMN(出库明细!$B:$B)))=Q$1))" 这些东西。