SOLVED

Fonction Somme Si ens

%3CLINGO-SUB%20id%3D%22lingo-sub-2923156%22%20slang%3D%22fr-FR%22%3ESum%20If%20ens%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2923156%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20create%20a%20formula%20to%20calculate%20the%20number%20of%20successes%20in%20a%20course%20for%20lists%20of%20students%20so%20I%20thought%20I%20used%20the%20sum%20if%20formula%20but%20there%20is%20always%20an%20error.%20I%20explain%20my%20need%2C%20I%20would%20like%20that%20in%20sheet%201%20my%20column%20D%20calculation%20from%20the%20report%20sheet%20taking%20into%20account%20the%20name%20of%20the%20student%20the%20number%20of%20successes%20in%20the%20column%20L%20cumulative%20grade%20so%20it%20is%20necessary%20that%20my%20formula%20takes%20into%20account%20the%20name%20of%20the%20student%20and%20that%20from%20there%2C%20a%20calculation%20is%20made%20to%20add%20the%20notes%20of%20the%20column%20L%20which%20are%20%26gt%3B%20%3D%20to%2060%20and%20that%20I%20arrive%20in%20the%20column%20D%20to%20a%20result%20like%206%20in%20the%20case%20of%20Lauri%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2923156%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2923245%22%20slang%3D%22en-US%22%3ERe%3A%20Fonction%20Somme%20Si%20ens%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2923245%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1205984%22%20target%3D%22_blank%22%3E%40Kathy_Gagne%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DSUMPRODUCT((Rapport_20211103_1047!%24B%242%3A%24B%2489%3DFeuil1!B2)*(Rapport_20211103_1047!%24L%242%3A%24L%2489%26gt%3B%3D60))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DCOUNTIFS(Rapport_20211103_1047!%24B%242%3A%24B%2489%2CFeuil1!B2%2CRapport_20211103_1047!%24L%242%3A%24L%2489%2C%22%26gt%3B%3D60%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBoth%20formulas%20work%20in%20my%20spreadsheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Bonjour, 

 

J'aimerais créer une formule pour calculer le nombre de succès dans un cours pour des listes d'étudiants donc j'ai pensé utilisé la formule somme si mais il y a toujours une erreur. Je vous explique mon besoin, j'aimerais que dans la feuille1 ma colonne D calcul à partir de la feuille Rapport en tenant compte du nom de l'étudiant le nombre de succès dans la colonne L note cumulée donc il faut que ma formule tienne compte du nom de l'étudiant et qu'à partir de là, un calcul se fasse pour additionner les notes de la colonne L qui sont >= à 60 et que j'arrive dans la colonne D à un résultat comme 6 dans le cas de Lauri 

2 Replies
best response confirmed by Kathy_Gagne (New Contributor)
Solution

@Kathy_Gagne 

=SUMPRODUCT((Rapport_20211103_1047!$B$2:$B$89=Feuil1!B2)*(Rapport_20211103_1047!$L$2:$L$89>=60))

 

=COUNTIFS(Rapport_20211103_1047!$B$2:$B$89,Feuil1!B2,Rapport_20211103_1047!$L$2:$L$89,">=60")

 

Both formulas work in my spreadsheet.

thank you so much !!! it's perfect @Quadruple_Pawn