表列數據 依月份取值 (13632)

D2:E16=SUMIFS(J:J,$G:$G,LOOKUP($A2,$G$4:$G$5,$G$4:$G$5),$H:$H,$B2)

另解=SUMIFS(J:J,$G:$G,EDATE($G$2,6*(MONTH($A2)>6)),$H:$H,$B2)