總和 指定月份 表示1月至該月 (13402)

B13=SUMPRODUCT((SUBSTITUTE(A2:A6," ",)=A13)*(LEFTB(B1:G1,2)-LEFTB(B9,2)<=0)*B2:G6)

另解=SUMPRODUCT((A13=SUBSTITUTE(A2:A5," ",))*OFFSET(B2:B5,,,,MATCH(B9,B1:G1,)))



留言