在面板数据表的C2写公式:=sumproduct((indirect(c$1&"!a2:a1000")=$a2)*(indirect(c$1&"!b1:bb1")=$b2)*indirect(c$1&"!b2:bb1000"))右拉填充,下拉填充
