=SOMMEPROD((ANNEE(B7+LIGNE(INDIRECT("1:"&E7-B7))-1)=D11)*F11)+
SOMMEPROD((ANNEE(B7+LIGNE(INDIRECT("1:"&E7-B7))-1)=D12)*F12)+
SOMMEPROD((ANNEE(B7+LIGNE(INDIRECT("1:"&E7-B7))-1)=D13)*F13)+
SOMMEPROD((ANNEE(B7+LIGNE(INDIRECT("1:"&E7-B7))-1)=D14)*F14)+
SOMMEPROD((ANNEE(B7+LIGNE(INDIRECT("1:"&E7-B7))-1)=D15)*F15)