Habit Tracker: x Marks, COUNTIF per Habit & a Streak Counter
All lessons
- Habit Tracker: x Marks, COUNTIF per Habit & a Streak CounterFree
- To-Do & Task Tracker: Status, Due Dates, Overdue Flags & % DoneFree
- Expense Tracker: Categories, SUMIFS by Month & Budget vs Actual Pro
- Reading Goal Tracker: Progress %, Pace Needed per Day & On Track? Pro
- Workout Log: Volume, Week Numbers, Weekly Totals & Personal Bests (MAXIFS) Pro
- Mini-Gantt Project Timeline: Durations & Formula Rules that Shade the Weeks Pro
- Savings Goal Tracker: Running Balance, Progress % & Months to Goal (with a Chart) Pro
- Tracker Dashboard: KPIs from Every Tracker & a Budget vs Actual Chart Pro
You are not signed in — the lab works, but your progress is not saved. Start free
Read first
In Excel: make the marks easy to type
- Select the grid B2:E15, Data > Data Validation > List, Source:
x,-. Now every cell offers a drop-down with the two allowed marks. - Prefer a real tick? Use Insert > Checkbox (Microsoft 365): a ticked box is TRUE, so count with
=COUNTIF(B2:B15,TRUE). - Add the next weeks by inserting rows above the Days done row: the COUNTIF ranges grow automatically.
Loading the spreadsheet…