總計 1月到指定月 (14006)

B3:C9=SUMPRODUCT(F3:AB3*(F$2:AB$2=B$2)*((0&LEFTB($F$1:$AB$1,2))-LEFTB($A$1,2)<=0))

另解=SUMPRODUCT(N(OFFSET($E3,,ROW(INDIRECT("1:"&LEFTB($A$1,2)))*2-(B$2=$B$2))))