加總 依年度 (10791)

F2=SUMPRODUCT((YEAR(B$2:B$13)=E2)*C$2:C$13)

慢且同列有非數字 有誤=SUMPRODUCT((YEAR(B:B)=E2)*C:C)

另解=NPV(-2,SUMIF(B:B,"<"&EDATE(E2&-1,{0,12}),C:C))