Hi,

One solution is:
AA......AB
1999....=SUM(($V$5:$V$2050)*(YEAR($Z$5:$Z$2050)=AA 1))
.............
2004....=SUM((...

Confirm the Formula with Ctrl+Shift+Enter not just Enter.

Regards,
Ola