統計金額 距今天前區間 (13242)

F2:F5{=SUM((IF(B$2:B$12<=H$2,YEARFRAC(IF({1},B$2:B$12),H$2)*12)<=ROW(A3)*(6+(ROW(A3)=4)*99))*C$2:C$12)-SUM(F$1:F3)

另解{=NPV(-2,SUMIF($B:$B,"<"&EDATE(H$2,IF(ROW(A1)=4,{-999,6},{0,6})-6*ROW(A1)),$C:$C))