=SIERREUR(MOYENNE(PETITE.VALEUR(SI((C$2:C$32=K2)*ESTNUM(-SUBSTITUE(G$2:G$32;".";","));--SUBSTITUE(G$2:G$32;".";","));1);PETITE.VALEUR(SI((C$2:C$32=K2)*ESTNUM(-SUBSTITUE(G$2:G$32;".";","));--SUBSTITUE(G$2:G$32;".";","));2));SIERREUR(PETITE.VALEUR(SI((C$2:C$32=K2)*ESTNUM(-SUBSTITUE(G$2:G$32;".";","));--SUBSTITUE(G$2:G$32;".";","));1);""))
=SI(($C$2:$C$32=$K2)*ESTNUM(-SUBSTITUE($G$2:$G$32;".";","));--SUBSTITUE($G$2:$G$32;".";","))
=SI(($C$2:$C$32=$K2)*ESTNUM(-SUBSTITUE($G$2:$G$32;".";STXT(1/10;2;1)));--SUBSTITUE($G$2:$G$32;".";STXT(1/10;2;1)))
=SIERREUR(MOYENNE(PETITE.VALEUR(matrice;1);PETITE.VALEUR(matrice;2));SIERREUR(PETITE.VALEUR(matrice;1);""))