SOMMEPROD((A1:A100>=B2)*(A1:A100<=B3)*(C1:D100<>"")*ESTNUM(EQUIV(B1:B100;G2:G5;0)))
=SOMMEPROD((A:A>=B2)*(A:A<=B3)*(C:D<>"")*ESTNUM(EQUIV(B:B;G2:G5;0)))
=MOYENNE(SI((A:A>=B2)*(A:A<=B3)*(C:D<>"")*(ESTNUM(EQUIV(B:B;G2:G5;0)));C:D))
=MOYENNE(SI((A:A>=B2)*(A:A<=B3)*(C:D<>"")*(ESTNUM(EQUIV(B:B;G2:G3;0)));C:C))
=MOYENNE(SI((A:A>=B2)*(A:A<=B3)*(C:D<>"")*(ESTNUM(EQUIV(B:B;G2:G3;0)));D:D))