跨表 累计销售月 (9842)

B3:B6=VLOOKUP(A3,INDIRECT(A$1&"!A1:B17"),2,0)

C3=SUMPRODUCT(SUMIF(INDIRECT("'"&ROW(INDIRECT("1:"&LEFTB(A$1,2)))&"月'!A2:A17"),A3,INDIRECT("'"&ROW(INDIRECT("1:"&LEFTB(A$1,2)))&"月'!B2:B17")))