You can view Part One , Part Two and Part Three of this series.

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