=SOMME.SI(A$2:A$24;$J2;B$2:B$24)+SOMME.SI(C$2:C$24;$J2;D$2:D$24)+SOMME.SI(E$2:E$24;$J2;F$2:F$24)+SOMME.SI(G$2:G$24;$J2;H$2:H$24)
=SOMMEPROD(($A$2:$A$24=J2)*($B$2:$B$24))+SOMMEPROD(($C$2:$C$24=J2)*($D$2:$D$24))+SOMMEPROD(($E$2:$E$24=J2)*($F$2:$F$24))+SOMMEPROD(($G$2:$G$24=J2)*($H$2:$H$24))
=SOMMEPROD((A$2:G$24=J2)*(B$2:H$24))
=SOMME(SI((MOD(COLONNE(A$2:G$24);2)=1)*(A$2:G$24=J2);B$2:H$24))
=SOMMEPROD((A$2:G$24=J2)*(A$1:G$1="Réf")*(B$2:H$24))