In this video, we are going to look at how to summarize our year to date (YTD) numbers. We are using the Iferror() and Indirect() functions to pull in the data from the matching sheets. You can download the completed file here
- What I learned from the 2022 Tour de France
- Meet Aggregate – the function that helps you wrangle hidden rows and subtotals in your formulas..
- How to identify total of top three scores
- Creating a KPI Dashboard – Part Five – Putting it all together in our dashboard
- Creating a KPI Dashboard – Part Four – Putting together our annual stats