que cela additionne dans la cellule Z1.
=si(et(A1="X";M1="X";T1="X");Addition de quoi ?;Sinon quoi)
=NB.SI(D4;"X")+NB.SI(M4;"X")+NB.SI(V4;"X")+NB.SI(AE4;"X")+NB.SI(AN4;"X")
=N(D4="X")+N(M4="X")+N(V4="X")+N(AE4="X")+N(AN4="X")
=SOMMEPROD(($D$1:$AV$1=$AW$2)*($D4:$AV4="x"))