Like-for-Like (Same-Store) Growth with COUNTIFS Flags
This lesson is part of the course
In this lesson
You flag which of Larkspur's stores are comparable with COUNTIFS on a closure log and the opening dates, then compare like-for-like growth with total growth.
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
- Month Keys with EOMONTH: Group Any Date into Its Month Locked
- Month-to-Date (MTD): SUMIFS Between the Month Start and the Report Date Locked
- Year-to-Date (YTD) and Prior-Year YTD with SUMIFS and EDATE Locked
- Year-over-Year (YoY): Variance, Growth % and the "New" Case Locked
- Rolling 12 Months: Moving Totals, Averages and a Trend Chart Locked
- Fiscal Years Starting in April: FY, Fiscal Quarter and Fiscal YTD Locked
- Like-for-Like (Same-Store) Growth with COUNTIFS Flags Locked
- Capstone: KPI Tiles (Month, YTD, YoY, R12) and a Current vs Prior Year Chart Locked