指定年 統計年 季 月 周 (14452)

G2=NPV(-2,SUMIF(B:B,"<"&EDATE(DATE(F2,1,1),{0,12}),C:C))

G5=NPV(-2,SUMIF(B:B,"<"&EDATE(DATE(F$2,F5*3-2,1),{0,3}),C:C))

J2=NPV(-2,SUMIF(B:B,"<"&EDATE(DATE(F$2,I2,1),{0,1}),C:C))

G10=SUMPRODUCT((WEEKNUM(+B$2:B$17,2)=F10)*(YEAR(B$2:B$17)=F$2)*C$2:C$17)