Ola, this generated a #VALUE
=SUM(IF(ISNUMBER($V$5:$V$2050+$Z$5:$Z$2050);($V$5: $V$2050)*(YEAR($Z$5:$Z$2050)=AS2);0))

(After the semicolon, the 2 ranges are not hilighted in a color,
indicating that it doesn't like it.)

Pierre