AtHome
XLDnaute Nouveau
La formule doit calculer le total des "1" et des "0" "qui se suivent" (cumulés) (colonne W) sans tenir compte des cellules (vides) (qui ne doivent pas arrêter le calcul), MAIS en arrêtant immédiatement le calcul à la première rencontre : d'un chiffre zéro ( donnée "-1") ou du chiffre un (donnée "1").
J'espère avoir été précis et pas trop confus dans le descriptif de mon problème, s'il s'est possible sans formule de type "matricielle" double merci
| données | (formule du résultat) | |||||
| colonne W | colonne AD | |||||
| W13 | = | 0 | AD13 | = | -1 | |
| W14 | = | 0 | AD14 | = | -2 | |
| W15 | = | (vide) | AD15 | = | -2 | |
| W16 | = | 1 | AD16 | = | 1 | |
| W17 | = | 1 | AD17 | = | 2 | |
| W18 | = | (vide) | AD18 | = | 2 | |
| W19 | = | (vide) | AD19 | = | 2 | |
| W20 | = | (vide) | AD20 | = | 2 | |
| W21 | = | (vide) | AD21 | = | 2 | |
| W22 | = | 0 | AD22 | = | -1 | |
| W23 | = | 0 | AD23 | = | -2 | |
| W24 | = | 1 | AD24 | = | 1 | |
| W25 | = | 1 | AD25 | = | 2 | |
| W26 | = | 1 | AD26 | = | 3 | |
| W27 | = | (vide) | AD27 | = | 3 | |
| W28 | = | (vide) | AD28 | = | 3 | |
| W29 | = | 1 | AD29 | = | 4 | |
| W30 | = | 1 | AD30 | = | 5 | |
| W31 | = | 1 | AD31 | = | 6 | |
| W32 | = | 1 | AD32 | = | 7 | |
| W33 | = | 0 | AD33 | = | -1 | |
| W34 | = | 0 | AD34 | = | -2 | |
| W35 | = | (vide) | AD35 | = | -2 | |
| W36 | = | 1 | AD36 | = | 1 | |
| W37 | = | 0 | AD37 | = | -1 | |
| W38 | = | 0 | AD38 | = | -2 | |
| W39 | = | 0 | AD39 | = | -3 | |
| W40 | = | (vide) | AD40 | = | -3 | |
| W41 | = | (vide) | AD41 | = | -3 | |
| W42 | = | 1 | AD42 | = | 1 | |
| W43 | = | 1 | AD43 | = | 2 | |
| W44 | = | 1 | AD44 | = | 3 | |
| W45 | = | 1 | AD45 | = | 4 | |
| W46 | = | (vide) | AD46 | = | 4 | |
| W47 | = | (vide) | AD47 | = | 4 | |
| .. | ... |