Expense Tracker: Categories, SUMIFS by Month & Budget vs Actual
This lesson is part of the course
In this lesson
You add a month column to Maya's expense log, total it by category and month with SUMIFS, compare March with the budget and flag the overspent categories.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Habit Tracker: x Marks, COUNTIF per Habit & a Streak Counter Locked
- To-Do & Task Tracker: Status, Due Dates, Overdue Flags & % Done Locked
- Expense Tracker: Categories, SUMIFS by Month & Budget vs Actual Locked
- Reading Goal Tracker: Progress %, Pace Needed per Day & On Track? Locked
- Workout Log: Volume, Week Numbers, Weekly Totals & Personal Bests (MAXIFS) Locked
- Mini-Gantt Project Timeline: Durations & Formula Rules that Shade the Weeks Locked
- Savings Goal Tracker: Running Balance, Progress % & Months to Goal (with a Chart) Locked
- Tracker Dashboard: KPIs from Every Tracker & a Budget vs Actual Chart Locked