Forum Discussion
Automatiser une tache en utilisant somme.si
Belsam_mzh Okay! That complicates the matter. I would put all ID's and Values in one list with an extra column for the Q-Ex-number. Then separate and focus on all IDs that exist more than three times. Remove the duplicates (i.e. where ID-1 & Q-1 equals ID-2 & Q-2). Then you are (probably) left with no more than three IDs, that you can re-join with the other data. Now you can do the SUMIF formula (SOMME.SI) as there will not be any ID with more than 3 occurrences.
Not something you do in one simple formula, I'm afraid. At least, not one I can think of right now. Personally, I would use PowerQuery. Although not difficult to learn, perhaps a bit overwhelming since you mention to be new to Excel.
Have added a few chaat to your file demonstrating the steps you may have to do. Use only a very small portion of the data though.
Riny_van_EekelenRiny_van_Eekelen
Vous avez raison pour k7 j'ai le corrigé.
Pour l'identifiant 1229144 les valeurs de Q_EX1 et Q_EX2 sont les mêmes E13=G4 , E14=G5 et E15=G6 donc je vais sommer pour I juste 3 valeurs et non pas les 6.
Dans la formule chaque ID dois être répéter au maximum trois fois et si un même identifiant existe plus que 3 fois dans entre ID_EX1 et ID_EX2 je passe à comparer les Q_EX1 et Q_EX2,
si ID_EX1 = ID_EX2 et Q_EX1=Q_EX2 pour Q je compte soit Q_EX1 soit Q_EX2
Belsam_mzh Okay! That complicates the matter. I would put all ID's and Values in one list with an extra column for the Q-Ex-number. Then separate and focus on all IDs that exist more than three times. Remove the duplicates (i.e. where ID-1 & Q-1 equals ID-2 & Q-2). Then you are (probably) left with no more than three IDs, that you can re-join with the other data. Now you can do the SUMIF formula (SOMME.SI) as there will not be any ID with more than 3 occurrences.
Not something you do in one simple formula, I'm afraid. At least, not one I can think of right now. Personally, I would use PowerQuery. Although not difficult to learn, perhaps a bit overwhelming since you mention to be new to Excel.
Have added a few chaat to your file demonstrating the steps you may have to do. Use only a very small portion of the data though.
- Merci beaucoup pour votre réponse et votre temps .