← 5 días para mejores hojas de cálculo contables
Lección 3 de 5
Day 3: Summarise with SUMIFS
Lo que podrás hacer
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
Paso 1 de 8 · 1 punto
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 |
Haz clic y arrastra sobre las celdas para ver aquí su Promedio, Recuento y Suma.
Rows 2 to 15 of 65
Name Box (Cuadro de nombres)B5fx