Excel Magic Trick 1537: SUMIFS & DAY Functions to calculate Average Daily Revenue

Download Excel Start Files: http://bit.ly/2FBEKxU
Entire page with all Excel Files for All Videos: http://bit.ly/1kSFWvs

In this video learn how to create an Excel Spreadsheet Formula solution that calculates the Average Daily Revenue with the SUMIFS and DAY Function. This solution comes from Chris McNeil at YouTube.

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.