发布时间：2019-07-31 09:44:02
=SUMPRODUCT(一部!$G$2:$G$999,1*(OFFSET(一部!$G$2:$G$999,0,SUM(COLUMN(一部!$D$2:$D$999)-COLUMN(一部!$G$2:$G$999)))=A2)*(OFFSET(一部!$G$2:$G$999,0,SUM(COLUMN(一部!$E$2:$E$999)-COLUMN(一部!$G$2:$G$999)))=B2))怎么引用不来数据
公式错误了