Habit Tracker: x Marks, COUNTIF per Habit & a Streak Counter
This lesson is part of the course
In this lesson
You turn a two-week habit grid into a live tracker: days done per habit with COUNTIF, a running streak counter with IF, the longest streak with MAX and green ticks with conditional formatting.
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