← 5 jours pour de meilleures feuilles de calcul comptables
Leçon 3 sur 5
Day 3: Summarise with SUMIFS
Ce que vous saurez faire
Total the clean lines by category and by week with SUMIFS, set them against the budget, and read the variance with the right sign.
Your manager's question is not 'show me the lines'. It is 'where did the money go this month, and how does that compare with the plan?'. SUMIFS answers it by adding only the lines that meet your conditions. It works today because Day 1 gave every category one spelling and every date a real value.
0 XP
Étape 1 sur 8 · 1 point
The pack needs the last day of the period. B4 holds 1 September 2026. In B5, return the last day of the month that B4 falls in.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | ||||
| 8 | ||||
| 9 | ||||
| 10 | ||||
| 11 | ||||
| 12 | ||||
| 13 | ||||
| 14 | ||||
| 15 |
Cliquez et faites glisser sur des cellules pour voir ici leur Moyenne, leur Nombre et leur Somme.
Rows 2 to 15 of 65
Zone NomB5fx