Somme et multiplication a condition multiple

Le 15/01/2026 à 12:07

Bonjour,

je souhaite simplifier la formule suivent afin de pouvoir facilement ajouter colonne ou ligne:

=((NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A2;'RELEVE TERRAIN'!$E$2:$E;$B$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$B3)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A2;'RELEVE TERRAIN'!$E$2:$E;$C$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$C3)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A2;'RELEVE TERRAIN'!$E$2:$E;$D$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$D3)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A2;'RELEVE TERRAIN'!$E$2:$E;$E$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$E3)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A2;'RELEVE TERRAIN'!$E$2:$E;$F$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$F3)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A2;'RELEVE TERRAIN'!$E$2:$E;$G$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$G3)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A2;'RELEVE TERRAIN'!$E$2:$E;$H$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$H3)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A2;'RELEVE TERRAIN'!$E$2:$E;$I$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$I3)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A2;'RELEVE TERRAIN'!$E$2:$E;$J$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$J3)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A2;'RELEVE TERRAIN'!$E$2:$E;$K$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$K3)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A2;'RELEVE TERRAIN'!$E$2:$E;$L$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$L3)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A2;'RELEVE TERRAIN'!$E$2:$E;$M$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$M3)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A2;'RELEVE TERRAIN'!$E$2:$E;$N$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$N3)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A2;'RELEVE TERRAIN'!$E$2:$E;$O$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$O3))+((NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A4;'RELEVE TERRAIN'!$E$2:$E;$B$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$B5)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A4;'RELEVE TERRAIN'!$E$2:$E;$C$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$C5)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A4;'RELEVE TERRAIN'!$E$2:$E;$D$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$D5)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A4;'RELEVE TERRAIN'!$E$2:$E;$E$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$E5)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A4;'RELEVE TERRAIN'!$E$2:$E;$F$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$F5)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A4;'RELEVE TERRAIN'!$E$2:$E;$G$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$G5)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A4;'RELEVE TERRAIN'!$E$2:$E;$H$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$H5)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A4;'RELEVE TERRAIN'!$E$2:$E;$I$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$I5)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A4;'RELEVE TERRAIN'!$E$2:$E;$J$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$J5)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A4;'RELEVE TERRAIN'!$E$2:$E;$K$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$K5)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A4;'RELEVE TERRAIN'!$E$2:$E;$L$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$L5)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A4;'RELEVE TERRAIN'!$E$2:$E;$M$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$M5)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A4;'RELEVE TERRAIN'!$E$2:$E;$N$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$N5)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A4;'RELEVE TERRAIN'!$E$2:$E;$O$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$O5))+((NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A6;'RELEVE TERRAIN'!$E$2:$E;$B$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$B7)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A6;'RELEVE TERRAIN'!$E$2:$E;$C$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$C7)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A6;'RELEVE TERRAIN'!$E$2:$E;$D$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$D7)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A6;'RELEVE TERRAIN'!$E$2:$E;$E$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$E7)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A6;'RELEVE TERRAIN'!$E$2:$E;$F$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$F7)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A6;'RELEVE TERRAIN'!$E$2:$E;$G$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$G7)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A6;'RELEVE TERRAIN'!$E$2:$E;$H$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$H7)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A6;'RELEVE TERRAIN'!$E$2:$E;$I$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$I7)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A6;'RELEVE TERRAIN'!$E$2:$E;$J$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$J7)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A6;'RELEVE TERRAIN'!$E$2:$E;$K$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$K7)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A6;'RELEVE TERRAIN'!$E$2:$E;$L$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$L7)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A6;'RELEVE TERRAIN'!$E$2:$E;$M$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$M7)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A6;'RELEVE TERRAIN'!$E$2:$E;$N$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$N7)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A6;'RELEVE TERRAIN'!$E$2:$E;$O$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$O7))+((NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A8;'RELEVE TERRAIN'!$E$2:$E;$B$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$B9)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A8;'RELEVE TERRAIN'!$E$2:$E;$C$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$C9)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A8;'RELEVE TERRAIN'!$E$2:$E;$D$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$D9)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A8;'RELEVE TERRAIN'!$E$2:$E;$E$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$E9)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A8;'RELEVE TERRAIN'!$E$2:$E;$F$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$F9)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A8;'RELEVE TERRAIN'!$E$2:$E;$G$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$G9)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A8;'RELEVE TERRAIN'!$E$2:$E;$H$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$H9)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A8;'RELEVE TERRAIN'!$E$2:$E;$I$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$I9)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A8;'RELEVE TERRAIN'!$E$2:$E;$J$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$J9)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A8;'RELEVE TERRAIN'!$E$2:$E;$K$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$K9)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A8;'RELEVE TERRAIN'!$E$2:$E;$L$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$L9)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A8;'RELEVE TERRAIN'!$E$2:$E;$M$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$M9)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A8;'RELEVE TERRAIN'!$E$2:$E;$N$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$N9)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A8;'RELEVE TERRAIN'!$E$2:$E;$O$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$O9))+((NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A10;'RELEVE TERRAIN'!$E$2:$E;$B$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$B11)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A10;'RELEVE TERRAIN'!$E$2:$E;$C$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$C11)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A10;'RELEVE TERRAIN'!$E$2:$E;$D$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$D11)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A10;'RELEVE TERRAIN'!$E$2:$E;$E$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$E11)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A10;'RELEVE TERRAIN'!$E$2:$E;$F$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$F11)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A10;'RELEVE TERRAIN'!$E$2:$E;$G$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$G11)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A10;'RELEVE TERRAIN'!$E$2:$E;$H$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$H11)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A10;'RELEVE TERRAIN'!$E$2:$E;$I$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$I11)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A10;'RELEVE TERRAIN'!$E$2:$E;$J$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$J11)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A10;'RELEVE TERRAIN'!$E$2:$E;$K$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$K11)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A10;'RELEVE TERRAIN'!$E$2:$E;$L$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$L11)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A10;'RELEVE TERRAIN'!$E$2:$E;$M$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$M11)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A10;'RELEVE TERRAIN'!$E$2:$E;$N$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$N11)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A10;'RELEVE TERRAIN'!$E$2:$E;$O$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$O11))+((NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A12;'RELEVE TERRAIN'!$E$2:$E;$B$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$B13)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A12;'RELEVE TERRAIN'!$E$2:$E;$C$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$C13)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A12;'RELEVE TERRAIN'!$E$2:$E;$D$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$D13)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A12;'RELEVE TERRAIN'!$E$2:$E;$E$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$E13)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A12;'RELEVE TERRAIN'!$E$2:$E;$F$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$F13)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A12;'RELEVE TERRAIN'!$E$2:$E;$G$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$G13)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A12;'RELEVE TERRAIN'!$E$2:$E;$H$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$H13)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A12;'RELEVE TERRAIN'!$E$2:$E;$I$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$I13)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A12;'RELEVE TERRAIN'!$E$2:$E;$J$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$J13)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A12;'RELEVE TERRAIN'!$E$2:$E;$K$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$K13)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A12;'RELEVE TERRAIN'!$E$2:$E;$L$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$L13)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A12;'RELEVE TERRAIN'!$E$2:$E;$M$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$M13)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A12;'RELEVE TERRAIN'!$E$2:$E;$N$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$N13)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A12;'RELEVE TERRAIN'!$E$2:$E;$O$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$O13))+((NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A14;'RELEVE TERRAIN'!$E$2:$E;$B$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$B15)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A14;'RELEVE TERRAIN'!$E$2:$E;$C$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$C15)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A14;'RELEVE TERRAIN'!$E$2:$E;$D$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$D15)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A14;'RELEVE TERRAIN'!$E$2:$E;$E$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$E15)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A14;'RELEVE TERRAIN'!$E$2:$E;$F$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$F15)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A14;'RELEVE TERRAIN'!$E$2:$E;$G$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$G15)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A14;'RELEVE TERRAIN'!$E$2:$E;$H$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$H15)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A14;'RELEVE TERRAIN'!$E$2:$E;$I$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$I15)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A14;'RELEVE TERRAIN'!$E$2:$E;$J$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$J15)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A14;'RELEVE TERRAIN'!$E$2:$E;$K$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$K15)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A14;'RELEVE TERRAIN'!$E$2:$E;$L$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$L15)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A14;'RELEVE TERRAIN'!$E$2:$E;$M$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$M15)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A14;'RELEVE TERRAIN'!$E$2:$E;$N$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$N15)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A14;'RELEVE TERRAIN'!$E$2:$E;$O$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$O15))+((NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A16;'RELEVE TERRAIN'!$E$2:$E;$B$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$B17)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A16;'RELEVE TERRAIN'!$E$2:$E;$C$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$C17)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A16;'RELEVE TERRAIN'!$E$2:$E;$D$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$D17)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A16;'RELEVE TERRAIN'!$E$2:$E;$E$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$E17)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A16;'RELEVE TERRAIN'!$E$2:$E;$F$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$F17)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A16;'RELEVE TERRAIN'!$E$2:$E;$G$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$G17)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A16;'RELEVE TERRAIN'!$E$2:$E;$H$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$H17)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A16;'RELEVE TERRAIN'!$E$2:$E;$I$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$I17)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A16;'RELEVE TERRAIN'!$E$2:$E;$J$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$J17)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A16;'RELEVE TERRAIN'!$E$2:$E;$K$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$K17)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A16;'RELEVE TERRAIN'!$E$2:$E;$L$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$L17)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A16;'RELEVE TERRAIN'!$E$2:$E;$M$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$M17)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A16;'RELEVE TERRAIN'!$E$2:$E;$N$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$N17)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A16;'RELEVE TERRAIN'!$E$2:$E;$O$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$O17))+((NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A18;'RELEVE TERRAIN'!$E$2:$E;$B$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$B19)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A18;'RELEVE TERRAIN'!$E$2:$E;$C$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$C19)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A18;'RELEVE TERRAIN'!$E$2:$E;$D$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$D19)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A18;'RELEVE TERRAIN'!$E$2:$E;$E$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$E19)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A18;'RELEVE TERRAIN'!$E$2:$E;$F$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$F19)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A18;'RELEVE TERRAIN'!$E$2:$E;$G$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$G19)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A18;'RELEVE TERRAIN'!$E$2:$E;$H$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$H19)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A18;'RELEVE TERRAIN'!$E$2:$E;$I$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$I19)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A18;'RELEVE TERRAIN'!$E$2:$E;$J$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$J19)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A18;'RELEVE TERRAIN'!$E$2:$E;$K$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$K19)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A18;'RELEVE TERRAIN'!$E$2:$E;$L$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$L19)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A18;'RELEVE TERRAIN'!$E$2:$E;$M$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$M19)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A18;'RELEVE TERRAIN'!$E$2:$E;$N$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$N19)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A18;'RELEVE TERRAIN'!$E$2:$E;$O$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$O19))+((NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A20;'RELEVE TERRAIN'!$E$2:$E;$B$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$B21)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A20;'RELEVE TERRAIN'!$E$2:$E;$C$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$C21)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A20;'RELEVE TERRAIN'!$E$2:$E;$D$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$D21)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A20;'RELEVE TERRAIN'!$E$2:$E;$E$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$E21)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A20;'RELEVE TERRAIN'!$E$2:$E;$F$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$F21)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A20;'RELEVE TERRAIN'!$E$2:$E;$G$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$G21)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A20;'RELEVE TERRAIN'!$E$2:$E;$H$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$H21)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A20;'RELEVE TERRAIN'!$E$2:$E;$I$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$I21)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A20;'RELEVE TERRAIN'!$E$2:$E;$J$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$J21)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A20;'RELEVE TERRAIN'!$E$2:$E;$K$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$K21)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A20;'RELEVE TERRAIN'!$E$2:$E;$L$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$L21)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A20;'RELEVE TERRAIN'!$E$2:$E;$M$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$M21)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A20;'RELEVE TERRAIN'!$E$2:$E;$N$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$N21)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A20;'RELEVE TERRAIN'!$E$2:$E;$O$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$O21))+((NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A22;'RELEVE TERRAIN'!$E$2:$E;$B$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$B23)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A22;'RELEVE TERRAIN'!$E$2:$E;$C$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$C23)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A22;'RELEVE TERRAIN'!$E$2:$E;$D$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$D23)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A22;'RELEVE TERRAIN'!$E$2:$E;$E$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$E23)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A22;'RELEVE TERRAIN'!$E$2:$E;$F$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$F23)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A22;'RELEVE TERRAIN'!$E$2:$E;$G$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$G23)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A22;'RELEVE TERRAIN'!$E$2:$E;$H$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$H23)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A22;'RELEVE TERRAIN'!$E$2:$E;$I$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$I23)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A22;'RELEVE TERRAIN'!$E$2:$E;$J$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$J23)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A22;'RELEVE TERRAIN'!$E$2:$E;$K$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$K23)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A22;'RELEVE TERRAIN'!$E$2:$E;$L$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$L23)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A22;'RELEVE TERRAIN'!$E$2:$E;$M$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$M23)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A22;'RELEVE TERRAIN'!$E$2:$E;$N$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$N23)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A22;'RELEVE TERRAIN'!$E$2:$E;$O$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$O23))+((NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A24;'RELEVE TERRAIN'!$E$2:$E;$B$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$B25)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A24;'RELEVE TERRAIN'!$E$2:$E;$C$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$C25)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A24;'RELEVE TERRAIN'!$E$2:$E;$D$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$D25)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A24;'RELEVE TERRAIN'!$E$2:$E;$E$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$E25)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A24;'RELEVE TERRAIN'!$E$2:$E;$F$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$F25)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A24;'RELEVE TERRAIN'!$E$2:$E;$G$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$G25)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A24;'RELEVE TERRAIN'!$E$2:$E;$H$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$H25)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A24;'RELEVE TERRAIN'!$E$2:$E;$I$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$I25)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A24;'RELEVE TERRAIN'!$E$2:$E;$J$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$J25)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A24;'RELEVE TERRAIN'!$E$2:$E;$K$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$K25)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A24;'RELEVE TERRAIN'!$E$2:$E;$L$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$L25)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A24;'RELEVE TERRAIN'!$E$2:$E;$M$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$M25)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A24;'RELEVE TERRAIN'!$E$2:$E;$N$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$N25)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A24;'RELEVE TERRAIN'!$E$2:$E;$O$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$O25))+((NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A26;'RELEVE TERRAIN'!$E$2:$E;$B$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$B27)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A26;'RELEVE TERRAIN'!$E$2:$E;$C$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$C27)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A26;'RELEVE TERRAIN'!$E$2:$E;$D$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$D27)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A26;'RELEVE TERRAIN'!$E$2:$E;$E$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$E27)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A26;'RELEVE TERRAIN'!$E$2:$E;$F$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$F27)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A26;'RELEVE TERRAIN'!$E$2:$E;$G$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$G27)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A26;'RELEVE TERRAIN'!$E$2:$E;$H$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$H27)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A26;'RELEVE TERRAIN'!$E$2:$E;$I$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$I27)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A26;'RELEVE TERRAIN'!$E$2:$E;$J$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$J27)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A26;'RELEVE TERRAIN'!$E$2:$E;$K$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$K27)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A26;'RELEVE TERRAIN'!$E$2:$E;$L$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$L27)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A26;'RELEVE TERRAIN'!$E$2:$E;$M$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$M27)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A26;'RELEVE TERRAIN'!$E$2:$E;$N$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$N27)+(NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;'RELEVE TERRAIN'!$G$2:$G;$A26;'RELEVE TERRAIN'!$E$2:$E;$O$1;'RELEVE TERRAIN'!$D$2:$D;C$31)*$O27))

Dans le fichier en exemple vous retrouvait cette formule en feuille "PM" cellule C34.

https://docs.google.com/spreadsheets/d/1SHJv3j-xOMJBX00QVi_XPyPl4H0sDQmu/edit?usp=sharing&ouid=11466...

Par avance merci de votre aide!

A+

Le 15/01/2026 à 23:42

Hello,

étant donné que cette formule est totalement indigeste le mieux serait de nous dire (en français) ce qu'elle est censé faire

Le 16/01/2026 à 09:24

Bonjour,

Comme le dit Nain, c'est littéralement impossible à "analyser" manuellement... Comment pouvez-vous atteindre une telle longueur de formule sans vous poser plus tot la question "n'existe-t-il pas un moyen plus simple de faire ce que je suis en train de faire ?"

En l'état, voici une proposition IA faute de comprendre vos tableaux & formules gigantesques :

=SOMMEPROD(
  NB.SI.ENS('RELEVE TERRAIN'!$B$2:$B;$Q$1;
            'RELEVE TERRAIN'!$G$2:$G;$A2;
            'RELEVE TERRAIN'!$E$2:$E;$B$1:$O$1;
            'RELEVE TERRAIN'!$D$2:$D;C$31);
  $B3:$O3
)

A condition que la formule ait bien ce but :

Pour chaque classe de diamètre (?) (B1:O1) et pour chaque essence (A2, A4, A6, …), compter les occurrences dans la feuille RELEVE TERRAIN puis multiplier par le coefficient correspondant (B3:O3, B5:O5, …).

Sur Excel la formule ne marche pas mais j'espère que dans Google Sheets elle ira.

En dehors de cela vous auriez vraiment intérêt à revoir tout le classeur en général, vous avez des imbrications de formules à n'en plus finir...

Un exemple très simple, vous avez l'imbrication suivante :

=SI(
    $A$1 = 10;
    'Copie de Tarif Chaudé 10'!B3;
    SI(
        $A$1 = 12;
        'Copie de Tarif Chaudé 12'!B3;
        SI(
            $A$1 = 14;
            'Copie de Tarif Chaudé 14'!B3;
            SI($A$1 = 16; 'Copie de Tarif Chaudé 16'!B3; "TARIF")
        )
    )
)

Qui peut s'écrire plus simplement avec SWITCH - Aide Éditeurs Google Docs

=SWITCH($A$1;
  10; 'Copie de Tarif Chaudé 10'!B3;
  12; 'Copie de Tarif Chaudé 12'!B3;
  14; 'Copie de Tarif Chaudé 14'!B3;
  16; 'Copie de Tarif Chaudé 16'!B3;
  "TARIF"
)

Imaginez avec 10 tarifs la longueur de l'empilement de SI...

Le 20/01/2026 à 16:32

Bonjour a vous deux,

Merci pour ces information, voici la traduction de la formule que je soutée simplifier:

Pour chaque qualité (D32:F32) et selon l'essence (R1) et pour chaque couple classe de diamètre et de hauteur (A2 et B1, A2 et C1,...A2 et P1; A4 et B1, A4 et C1,...A4 et P1; ...; A26 et B1, A326 et C1,..., A26 et P1) compter les occurrences dans la feuille RELEVE TERRAIN puis multiplier par le coefficient correspondant au couple diamètre et de hauteur.

J'espère être plus clair.

Merci pour votre aide !

Rechercher des sujets similaires à "somme multiplication condition multiple"