View Single Post
  #9   Report Post  
Ola
 
Posts: n/a
Default

Sorry,
Try this:
AB1:
=SUM(IF(ISNUMBER($V$5:$V$2050+$Z$5:$Z$2050);($V$5: $V$2050)*(YEAR($Z$5:$Z$2050)=AA1);0)

Ola