SOLVED
Home

Recherchev + somme par mois

%3CLINGO-SUB%20id%3D%22lingo-sub-1119868%22%20slang%3D%22fr-FR%22%3ESearchv%20-%20sum%20per%20month%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1119868%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI%20want%20to%20indicate%20in%20the%20cells%20of%20one%20sheet%20the%20sum%20of%20the%20lines%20per%20supplier%20according%20to%20another%20sheet%20that%20aggregates%20all%20the%20data.%20In%20the%20first%20sheet%2C%20each%20cell%20of%20each%20supplier%20is%20per%20month.%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20need%20more%20information%2C%20contact%20me%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1119868%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1120285%22%20slang%3D%22en-US%22%3ERe%3A%20Recherchev%20%2B%20somme%20par%20mois%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1120285%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F526878%22%20target%3D%22_blank%22%3E%40mspitz%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWithout%20seeing%20your%20sheet%2C%20I%20suspect%20it%20can%20be%20done%20with%20the%20SUMIF%20function.%20Please%20upload%20an%20example%20of%20your%20workbook%20without%20disclosing%20any%20private%20or%20confidential%20information.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1120400%22%20slang%3D%22en-US%22%3ERe%3A%20Recherchev%20%2B%20somme%20par%20mois%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1120400%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F526878%22%20target%3D%22_blank%22%3E%40mspitz%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20might%20have%20a%20language%20problem%20here%20as%20i%20do%20not%20speak%20French.%20Which%20columns%20from%20%22Donn%C3%A9es%202020%22%20would%20you%20want%20to%20sum%20in%20B7%20on%20the%20first%20sheet%3F%20Google%20translate%20wasn't%20very%20helpful.%20Sorry!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20it%20is%2C%20for%20example%2C%20column%20AE%2C%20the%20formula%20could%20be%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DSUMIFS('Donn%C3%A9es%202020'!%24AE%3A%24AE%2C'Donn%C3%A9es%202020'!%24A%3A%24A%2CB%246%2C'Donn%C3%A9es%202020'!%24D%3A%24D%2C'Nb%20FNCF%20%20Fournisseur'!A%247)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E.....%20but%20then%20you%20have%20to%20change%20your%20references%20in%20B6%3AM6%20to%20the%20month%20names.%20That%20would%20make%20it%20much%20easier.%20I%20did%20that%20in%20B6%20for%20%22janvier%22%20to%20test%20the%20formula.%20See%20the%20file%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1121761%22%20slang%3D%22fr-FR%22%3ERe%3A%20Researchv%20-%20sum%20per%20month%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1121761%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20the%20number%20of%20lines%20for%20each%20suppliers%20per%20month%20in%20the%20Nb%20FNCF%20Supplier%20spreadsheet.%3C%2FP%3E%3CP%3EI%20had%20datas%20on%20the%20file.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20need%20more%20information%2C%20don't%20hesitate%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1121850%22%20slang%3D%22en-US%22%3ERe%3A%20Recherchev%20%2B%20somme%20par%20mois%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1121850%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F526878%22%20target%3D%22_blank%22%3E%40mspitz%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20the%20attached%20file%20and%20let%20me%20know%20if%20this%20is%20what%20you%20want.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1120308%22%20slang%3D%22fr-FR%22%3ERe%3A%20Researchv%20-%20sum%20per%20month%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1120308%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThank%20you%20for%20your%20help.%3C%2FP%3E%3CP%3EPlease%20find%20the%20fictional%20file%20enclosed.%20The%20real%20one%20look%20like%20the%20same%20but%20with%20real%20information.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Bonjour,

Je souhaite indiquer dans les cellules d'une feuille la somme des lignes par fournisseur selon une autre feuille qui regroupe toutes les données. Dans la première feuille, chaque cellule de chaque fournisseur est par mois. 

Si besoin d'info supplémentaire, contactez-moi

Merci d'avance

6 Replies
Highlighted

@mspitz 

Without seeing your sheet, I suspect it can be done with the SUMIF function. Please upload an example of your workbook without disclosing any private or confidential information.

@Riny_van_Eekelen Thank you for your help.

Please find the fictional file enclosed. The real one look like the same but with real information.

Highlighted

@mspitz 

We might have a language problem here as i do not speak French. Which columns from "Données 2020" would you want to sum in B7 on the first sheet? Google translate wasn't very helpful. Sorry!

 

If it is, for example, column AE, the formula could be:

 

 

=SUMIFS('Données 2020'!$AE:$AE,'Données 2020'!$A:$A,B$6,'Données 2020'!$D:$D,'Nb FNCF  Fournisseur'!A$7)

 

 

..... but then you have to change your references in B6:M6 to the month names. That would make it much easier. I did that in B6 for "janvier" to test the formula. See the file attached.

Highlighted

@Riny_van_Eekelen 

I would like the number of lines for each suppliers per month  in the Nb FNCF Fournisseur spreadsheet.

I had datas on the file.  

If you need more information, don't hesitate

 

Highlighted
Solution

@mspitz 

Please see the attached file and let me know if this is what you want.

Highlighted

@Riny_van_Eekelen 

It's exactly what I want 

Thank you very much for your help 

Have a good day !