Jan 21 2020 05:23 AM
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
Jan 21 2020 08:00 AM
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.
Jan 21 2020 08:07 AM
@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.
Jan 21 2020 08:37 AM - edited Jan 21 2020 09:08 AM
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.
Jan 22 2020 12:10 AM
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
Jan 22 2020 01:08 AM
SolutionPlease see the attached file and let me know if this is what you want.
Jan 22 2020 01:39 AM
Jan 22 2020 01:08 AM
SolutionPlease see the attached file and let me know if this is what you want.