=SOMMEPROD(((plage_cellules_1="EVRP")+(plage_cellules_1="AT"))*
(plage_dates<>"")*(MOIS(plage_dates)=1)
=SOMMEPROD(($B$4:$B$12=$B17)*($C$4:$C$12<>"")*(MOIS($C$4:$C$12)=
MOIS("1/"&C$16)))
=SOMMEPROD(($B$4:$B$12=$B17)*(TEXTE($C$4:$C$12;"mmmm")=C$16))
=SOMMEPROD(($B$4:$B$12=$B17)*(TEXTE($C$4:$C$12;"mmmmaaaa")=
TEXTE("1/"&C$16&"/"&$B$16;"mmmmaaaa")))
=NB.SI(C4:C12;TEXTE(C4:C12;"mmmmaaaa")=TEXTE("1/"&C$16&"/"&$B$16;"mmmmaaaa"))
=SOMMEPROD((TEXTE($C$4:$C$12;"mmmmaaaa")=TEXTE("1/"&C$16&"/"&$B$16;
"mmmmaaaa"))*1)