總和 有年無月表全年 (14748)

E2=NPV(-2,SUMIF(B:B,"<"&EDATE(D2&-1,CHOOSE({1,2},0,IF(ISERR(FIND("-",D2)),12,1))),A:A))

另解=NPV(-2,SUMIF(B:B,"<"&EDATE(D2&-1,IF({1,0},,12^ISERR(FIND("-",D2)))),A:A))

另解=SUM(SUMIF(B:B,"<"&EDATE(D2&-1,IF({1,0},,12^ISERR(FIND("-",D2)))),A:A)*{-1,1})