Download Excel File: https://ift.tt/2xnWrLb
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs
In this video learn how to create Excel Worksheet Formulas for Total sales from daily dates, YOY Change in Sales and % YOY Change in Sales. Learn about the SUMIFS Function, the DATE Function and Comparative Operators for Upper and Lower Limits when adding sales between the first of the year and the end of the year. Also see a SUMPRODUCT Array Formula that is less efficient than SUMIFS.