總和 跨各月工作表 (9008)

 

  B3:B6=SUMPRODUCT(SUMIF(INDIRECT(ROW(INDIRECT("1:"&TRIM(LEFTB(A$1,2))))&"月!A2:A99"),A3,INDIRECT(ROW(INDIRECT("1:"&TRIM(LEFTB(A$1,2))))&"月!B2:B99")))

L3:P6=SUM(F3:$J3)