=SOMMEPROD((Programmation!$DN$3:$GD$3=B$6)*(Programmation!$DN$4:$GD$4=$A7)*(DECALER(Programmation!$DN$4;EQUIV($B$4;Programmation!$C$5:$C$134;0);;;69)))+SOMMEPROD(('Stock n-1'!$D$3:$BT$3=$A8)*(DECALER('Stock n-1'!$D$2;EQUIV($B$4;'Stock n-1'!$C$3:$C$238;0);;;69)))