Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel Magic Trick 1558: SUMIFS: Year Totals from Daily Sales, YOY Change, % YOY Change

Posted on by Annie D

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.

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.