Bonne nuit
.FormulaArray = "=SUMPRODUCT((R2C1:R17C1=MAX(IF((R2C2:R17C2=R[14]C5)*(R2C4:R17C4=""en vente""),R2C1:R17C1)))*(R2C2:R17C2=R[14]C5)*(R2C3:R17C3))-SUMPRODUCT((R2C1:R17C1=MIN(IF((R2C2:R17C2=R[14]C5)*(R2C4:R17C4=""en vente""),R2C1:R17C1)))*(R2C2:R17C2=R[14]C5)*(R2C3:R17C3))"
devrait t'éclairer