年度累計 用COUNTIF (13569)

G1 使用COUNTIFS=COUNTIFS(F$2:F2,">="&DATE(YEAR(F2),1,1),F$2:F2,"<="&DATE(YEAR(F2),12,31))

H2一般使用=SUMPRODUCT(N(YEAR(F$2:F2)=YEAR(F2)))