Forum Discussion
Recherchev + somme par mois
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
Please see the attached file and let me know if this is what you want.
6 Replies
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.
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.
