=VLOOKUP(B3,INDIRECT(D1&"!B:M"),2,0)以INDIRECT函数引用D1单元格的表名
1、2003\2007版本,C13公式:
=SUMPRODUCT(SUBTOTAL(103,INDIRECT("B"&ROW($2:$11)))*($B$2:$B$11=B13)*$C$2:$C$11)
下拉
如图:
2、2007版本,若求1月C13公式:
=SUMIFS($C$2:$C$11,$A$2:$A$11,">=2021-1-1",$A$2:$A$11,"<=2021-1-31",$B$2:$B$11,B13)