合计 往前推一年 (9742)

G3{=SUM(SUMIF(B:B,TEXT((G1&"28日")-ROW(1:12)*29+3,"YYY年M月"),C:C))

G4{=SUM(SUMIF(B:B,TEXT(EOMONTH(G1&"1日",-ROW(1:12)+1),"YYY年M月"),C:C))