=SOMME.SI.ENS(C7:C21;B7:B21;B4;C7:C21;">0")
Bonjour Hakimenne.
Code:=SOMME.SI.ENS(C7:C21;B7:B21;B4;C7:C21;">0")
=SOMME.SI.ENS(C7:C21;B7:B21;B4;C7:C21;">=0")
=SOMMEPROD(($B$7:$B$21=$B$4)*($C$7:$C$21>=0);$C$7:$C$21)
=SOMME.SI.ENS(C7:C21;B7:B21;B4;C7:C21;">0";A7:A21;E4)